Forum Discussion

STEPH0018's avatar
STEPH0018
Icon for Helper II rankHelper II
5 years ago

filtered dCalendar

Hi, guys. It is possible to create a filtered table, so that it is an auxiliary dCalendar, with a date range according to the date chosen by the user? For example, in the graph below, I would like ...
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Can't you use the regular date slicer set to "Between"?

 

You will need a Calendar Table for that though

  • STEPH0018's avatar
    STEPH0018
    Icon for Helper II rankHelper II
    5 years ago

    Hi, Paul, the intention is for the user to choose only one date.

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      5 years ago

      ...and the measure calculates what date range?

      • STEPH0018's avatar
        STEPH0018
        Icon for Helper II rankHelper II
        5 years ago
        SELECTEDVALUE(dCalendario[DATA]) and 
        LASTDATE(PARALLELPERIOD(dCalendario[DATA],-1, YEAR))