Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a Button to Switch between Custom time Intelligence

Hello All, I have a report that I need to switch between fortnight, month to date and 6month period to date(season). These time periods are based on a 445 calendar and are custom periods.   My Q...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    following on from this.

    Is there a way I can use the filter part of my calculate measure, as the slicer? This is what i have so far, trying to piece together different tutorials. the tutorial i was following creates a table that you can then use as the slicer:

    TimePeriod Selection =
    VAR TodayDate = MAX(SDAUSales[Date])
    VAR SeasonToDate =
    FILTER(
    ALL(BBCalendar),
    BBCalendar[FISCALCALENDARYEAR] = VALUES(BBCalendar[FISCALCALENDARYEAR])
    && BBCalendar[SeasonName] = VALUES(BBCalendar[SeasonName])
    && BBCalendar[Date]<=MAX(BBCalendar[Date])
    )
    VAR MonthToDate =
    FILTER(
    ALL(BBCalendar),
    BBCalendar[FISCALCALENDARYEAR] = VALUES(BBCalendar[FISCALCALENDARYEAR])
    && BBCalendar[MonthName] = VALUES(BBCalendar[MonthName])
    && BBCalendar[Date]<=MAX(BBCalendar[Date])
    )
    VAR Result =
    UNION(
    ADDCOLUMNS(
    CALENDAR(MonthToDate, TodayDate),
    "Selection","MTD"
    ),
    ADDCOLUMNS(
    CALENDAR(SeasonToDate, TodayDate),
    "Selection","STD"
    )
    )
    Return
    Result