Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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)