Dynamic Measure based on Dates

[arvindjha2050]

Hello Team,

I have a Filter and a Table.

Based on my selection of date in filter i want to know the sales on that particular day and also incremental sales after the selected date in a table

To achieve the same i used greater than format but it doesn't work.

Sum({$<[Last Update Date] = {"> $(=getfieldselections([Last Update Date]))"}>}[Sales])

Kindly help

Thanks,

Arvind

[arvindjha2050]

Hello Omar,

Thanks a lot for the reply.

The above worked ,but the same through YearMonth field doesn't work like below :

sum({<Year=,Month=,[Launch Date]={">$(=Date(min([[Launch Date.autoCalendar.YearMonth]])))

<$(=Date(max([[Launch Date.autoCalendar.YearMonth]])))"}>}Sales)

Actually i wanted filter to be as YearMonth

Thanks,

Arvind

[OmarBenSalem]

Hi Arvind,

When facing trouble with these expressions; always create text object;

and create a measure containing the parts you're having a doubt about;

I mean : create these measures:

=Date(min([[Launch Date.autoCalendar.YearMonth]]))

=Date(max([[Launch Date.autoCalendar.YearMonth]]))

and see what they're returning; and from there, begin to alter them untill it corresponds to ur need and they return the expected dates in the format of ur Launch Date

[arvindjha2050]

Hello Omar,

Actually i had already created these measures and they are returning correct values but not giving correct results :

sum({<Year=,Month=,[Launch Date]={">$(=Date(min([[Launch Date.autoCalendar.YearMonth]])))

<$(=Date(max([[Launch Date.autoCalendar.YearMonth]])))"}>}Sales)