cancel
Showing results for
Did you mean: Frequent Visitor

## Difference between 2 mesures in only month 9 every year

Hello guys,

I need to create a dax formula that calculate the difference between 2 mesures in month 9 of every year.

I used this formulat:

``Geplaned-Actuals-difference = CALCULATE(Abfrage1[Geplant],MONTH(Abfrage1[fiscaldate])=9)-CALCULATE(Abfrage1[Actuals(k)],MONTH(Abfrage1[fiscaldate])=9)``

and it didnt give me a logical result. what should I change ? 2 REPLIES 2  Super User

@Aymen_Soussi , a measure like this with help from date table

This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[Month] = 9))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1 && 'Date'[Month] = 9 ))

Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User! Frequent Visitor

@amitchandak I tired my formula with an other files containing simple data and it gives me logical result. The problem that I faced in this case is that when I do filters on date the values of the original mesures ( ['Geplant'] and ['Aktuals(K)'] ) that I'm using to calculate the result are changing. Is there any workaround to bypass this issue or I need first to work on the ['Geplant'] and ['Aktuals(K)'] to make their result stable even when I do date filters? Is a mesure considerated to be valid if give me the wanted result even if filter make it given different result ?   