Calculate % difference between months

[Syndicate_Admin]

Nice day.

I want to make the difference between % of one month compared to another.

I have a measure that calculates the % sold of each product based on the total (quantity sold of the product / total sold)

I want to make a table column 1 product column 2 January, column 3 February Column 4 (Difference between % February - % January)

Matrix table in Power BI where product are rows and months columns.

Product	January	February	Difference
Prod. 1	2.25%	1.17%	-1.08%
Prod. 2	4.15%	2.16%	-1.99%
Prod. 3	1.19%	5.36%	4.17%
Prod. 4	5.35%	3.90%	-1.45%
Prod. 5	3.45%	2.00%	-1.45%
Prod. 6	2.17%	1.50%	-0.67%

any suggestions or suggestions you may use?

Thank you.

[parry2k]

@Syndicate_Admin good to hear. Good luck!

[parry2k · Accepted solution]

@Syndicate_Admin this is the typical time intelligence functionality. You must add a date dimension to the model, and then use the DAX PREVIOUSMONTH function to get the % of the previous month, and from there the variance will be easy. To add a date dimension, check out my post here.

Check out my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions will ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to congratulate anyone who has helped solve your problem. It's a show of thanks!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultation.⚡

[Syndicate_Admin]

Thank you, this gave me the light and helped me solve the problem.