cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## How to subtract previous month data with specific category

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

1 ACCEPTED SOLUTION
Solution Sage

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 😀

3 REPLIES 3
Anonymous
Not applicable

Dear @Tanushree_Kapse & @jaideepnema

Thank you so much it really helps!

Solution Sage

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 😀

Impactful Individual

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!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors