Forum Discussion

JimmyKhan2022's avatar
JimmyKhan2022
Frequent Visitor
3 years ago
Solved

Ignore Page Level Filter on a Power BI Calculation Group

I have a Financial Year filter that does not select before 2021 . This is because there is PAGE level Filter that only allows the last 2 years , so only 2021 to 2023 . Problem is that I have a 1...
  • amitchandak's avatar
    amitchandak
    3 years ago

    JimmyKhan2022 , If you do not want more week then selected then you can get avg with help date/calendar table

     

    14 Month Avg = CALCULATE(AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Value)))
    ,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-14,MONTH))

     

    Or window function

     

    Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

JimmyKhan2022 , If you do not want more week then selected then you can get avg with help date/calendar table

 

14 Month Avg = CALCULATE(AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Value)))
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-14,MONTH))

 

Or window function

 

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc