Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Master

## last day

Hi all,

i want to display the chart only monthend values only

currently am getting total month numbers

used  dimension:  =aggr(if([Month Year Num]>'\$(vSelectedMonth)',[Month Year]),[Month Year])

Exp:  Count(Number)   so it is giving me last 10 months data in bar chart

so now I want  only each monthend date how many numbers are there that only need to show?

how to use monthend in  my measure.

1 Solution

Accepted Solutions
MVP

May be this

Count(If(Date = Floor(MonthEnd(Date)) or Max(TOTAL Date), Number))

7 Replies
MVP

May be this as your expression

Count(If(Date = Floor(MonthEnd(Date)), Number))

Partner - Master

your dates in the fact table include the day or only month and year?

I can walk on water when it freezes
Master
Author

thanks sunny  its working but

there is one logic in between

I want to get till last month it needs to show  and but current month  should show max date count  ?

Master
Author

how to show only max month should show max date numbers and   all previuos months should show  monthend date count

MVP

May be this

Count(If(Date = Floor(MonthEnd(Date)) or Max(TOTAL Date), Number))

Master
Author

thanks sunny its working   can you explain how max(total Date) will work?

MVP

Max(TOTAL Date) will be evaluated as True for the Max Date and false for every other Date....

Community Browser