Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have Sold To Customer in the blacked out row and sales dollars based on years/months in the slicers. It all comes from the same database. I've read every post out there and can not figure out how to add a % difference column between 2016/2017 and 2017/2018. Data is not a static database, it updates from a server 4X per day to populate the numbers. How do I write this in DAX to add % increase or decrease based on each row in the columns?
Solved! Go to Solution.
I'm doing almost the same exact calculation for certain costs, too. I use the exact same slicer you're using. Here's how I've done it.
I'm sure there is a more elegant way to do this with DAX, but I'm still learning Power BI, so my formulas and procedures are more basic. Hope this helps.
Hope this helps!
I'm doing almost the same exact calculation for certain costs, too. I use the exact same slicer you're using. Here's how I've done it.
I'm sure there is a more elegant way to do this with DAX, but I'm still learning Power BI, so my formulas and procedures are more basic. Hope this helps.
Hope this helps!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |