Forum Discussion

BSM1985's avatar
BSM1985
Icon for Helper IV rankHelper IV
6 years ago
Solved

Last N Months

Hello Team,   I have a bar chart with date on x-axis and profit on y-axis. The requireent is to have the buttons on top like "Last 1 Month", "Last 2 Months" and "Last 6 Months" as shown in attached...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi BSM1985 ,

    I just updated your sample pbix file, please check if that is what you want. You can get the updated file from this link.

    Best Regards

    Rena

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

BSM1985 You can do this with a column in your table where you flag items last 2 months, etc. Otherwise, you can do it in a measure like:

Measure =
  VAR __Selected = MAX('Slicer'[Value])
  VAR __Calc = <some calculation>
RETURN
  IF(MAX('Date'[Date]) < TODAY() && MAX('Date'[Date])>=DATE(YEAR(TODAY()),MONTH(TODAY()),1),__Calc,BLANK())

As an example.