How to subtract the values between two months in the same column using calculated column

[Swamy3105]

Hi Experts,

please help me to acheive the below:

I tried hard but nothing is working.

I want to subtract the value  = Dec-Jan = -16.28

Please help me on this.

Regards.,

Swamy

[v-xiandat-msft]

Hi @Swamy3105 ,

Thank you for @Syndicate_Admin answer , and I have other suggestions:

Below is my table:

The following DAX might work for you:

Column = 
 VAR _month = MIN('Table'[Year])
 VAR _new_month = MONTH(EDATE(_month,1))
 VAR _a = CALCULATE(MAX('Table'[FIFO]),FILTER('Table',MONTH('Table'[Year]) = _new_month))
 VAR _b = CALCULATE(MAX('Table'[FIFO]),FILTER('Table',MONTH('Table'[Year]) = MONTH(_month)))
 RETURN
 _b - _a

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Swamy3105]

Hi @Syndicate_Admin 

thanks for your dax, but I need to subtract the value from current month to previous month as below:

Regards.,

Swamy

[Syndicate_Admin]

Nice