Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a measure which takes max(Sales) . I have created a table.
Month. Max(Sales)
July. XXX
August XXX
I have a filter date(YYYY-MM-DD), when i filter out particular dates in a month the max(sales) value does not changes according to the filtered out dates.
Does Month and Date are Related? if Date and Month are not related it will not impact on table.
if Its Related then try selecting other values in Dates
So, i have a field date which shows dates in (yyyy-mm-dd). In the table to show month i have taken[date.autoCalendar.YearMonth]
so want to Select Latest month for bookmark? please share some sample if possible
Kindy check whether the autogenerated date and your table month are interlinked , if not the data wont match
1. How you are matching the date field with month field ?
2. How the data model linked between both?
There is only one field date. The month is coming from the date field itself using the expression - [date.autoCalendar.YearMonth]