Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Filter

HI Guys,   I have a quick question: - Lets say I filtered my entire report on Calendar Date is in "Previous Week" - But I need one of my measures to check if something was assorted in the last 6 ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 

    The page filter only changes the displayed visual, the calculating result still take the last 6 months value.

    For example, I have a measure calculate the last month value, when I set page filter to before 2020/2/1. The result 193 doesn't change, only the visual is filtered. 

     

    Best, regards

    Paul Zheng

amitchandak's avatar
amitchandak
Super User
6 years ago

Seems fine or you can try like example below

Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],today(),-6,MONTH))