Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have created a table as below and I would like to calculate % increase between "Current" and "LY Actuals" i.e. for Sales it will be 4% (52-50)/50. How can I code this? Thanks for help!
Example:
Here are the setting of this table, and the Sales & Orders are a calculated measures.
Solved! Go to Solution.
Apolgise had to repost as I made a mistake on the previous post, so the forumla should be:
Many Thanks
Ben
No worries at all, happy that I could help solve your problem 🙂
Thanks for suggestion. I don't have a column called "Last Year" and "This Year" but both are included in one column as "Scenario". As such I could not follow the formula above. How to refine it?
Apolgise had to repost as I made a mistake on the previous post, so the forumla should be:
Many Thanks
Ben
Hey,
So the forumla I would use to solve this problem is as follows:
You should end up with somthing like this:
Please let me know if you have any further questions,
Many Thanks
Ben
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |