Show last 6 months based on user single slicer selection (20:03)

https://www.youtube.com/watch?v=d8Rm7dwM6gc 

Creates a copy of Date table (PreviousDates) that will be filtered to the last 6 months of dates based on the slicer selection, use PreviousDates to filter Date table, create a calculation group that will calculate previous 6 months of SELECTEDMEASURE(), finally apply calculation item as a filter of the visual to render the previous 6 months based on slicer selection.

Calculation item CALCULATE must REMOVEFILTER on Date table and KEEPFILTERS on PreviousDates


Calculation Group starts at 14:00

Comments