Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Trouble with creating a certain measure

I have a created measure that tells me what the change in Revenue is based on a serious of variables I can select and change. One of these varibles is the Discount. I now need to calculate what the change of (change in reveneue) incrementally going uo or down in discount. 

 

For example. The new discounts I choose are 75%, 76%, 77% where it was originally 74%. I now have the change in revenue of the discount going from 74% to 75%, 74% to 76%, and 74% to 77%. Now I need a measure that tells me what the change in (change of revenue) is going from 74-75, 75-76, 76-77.

 

Hopefully this makes sense.

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,

You can refer the following links to get the different between new discount and old discount. 

Solved: Calculate difference from previous month - Microsoft Fabric Community

 

difference=
sum(DW_Data_Salg[Inntekt])-CALCULATE(SUM(DW_Data_Salg[Inntekt]),PREVIOUSMONTH(DW_Data_Salg[DATO].[Date]))

 

Solved: Dax for Current Month & Previous Month - Microsoft Fabric Community

Solved: Current Month vs Previous Month - Microsoft Fabric Community 

 

If the above ones can't help you get the expected result, please provide some raw data (exclude sensitive data) with Text format in your tables and your expected result. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

 

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors