Forum Discussion

Adlu's avatar
Adlu
Frequent Visitor
3 years ago

Measure calculating change + filter

I have a table like the one below, filtered by Nov, Dec, and 2021, 2022:

Now, the "Change" in November 2022 is calculating October 2022 vs November 2022. How to adjust the measure to make it better and show in such situation December 2021 vs November 2022 change?

Change = divide([Cash Balances (EUR)]-[Previous month value], [Previous month value], "-")
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Adlu . Sales vs 11 month before sales

     

     

    example

     

    MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
    last 11  MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-11,MONTH)))

     

    11 Months behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-11,Month))

     

    Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
    Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
    Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s