topic Re: How to subtract previous month data with specific category in DAX Commands and Tips

How to subtract previous month data with specific category

Anonymous — Mon, 27 Sep 2021 04:27:13 GMT

Hi,

I'm very new to this PowerBI and I need your help.

So I have this data of variable cost and revenue from different products and different month. So I want to subtract the Q1 Value from 2nd month and previous month for each product. For example for Variable cost for biscuit the difference is 6000 (this month) - 5000 (last month) = 1000.

The desired outcome is shown on the right column.

Kindly need your help on this.

Thank you

Re: How to subtract previous month data with specific category

Tanushree_Kapse — Mon, 27 Sep 2021 05:01:23 GMT

Hi Anonymous ,

Previous month Sale= CALCULATE(SUM(Table(Q1), PARALLELPERIOD(Table(Month), -1, Month)

Current month= SUM(Table(Q1))
Difference= Current month - Previous month Sale

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks!

Re: How to subtract previous month data with specific category

jaideepnema — Mon, 27 Sep 2021 05:10:53 GMT

Hi Anonymous ,

Create a measure like this:

Desired Result = 

var previousmonthvalue=CALCULATE(SUM(Data[Q1]),FILTER(ALLEXCEPT(Data,Data[Status],Data[Product]),Data[Month]=SELECTEDVALUE(Data[Month])-1))

return IF(ISBLANK(previousmonthvalue),0,SUM(Data[Q1])-previousmonthvalue)

This will give you the desired output:

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

Re: How to subtract previous month data with specific category

Anonymous — Mon, 27 Sep 2021 08:35:06 GMT

Dear Tanushree_Kapse & jaideepnema

Thank you so much it really helps!