Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello All,
I have a simple report as can be seen below
Budget run rate = Total budget for the month/ # of days
Actual Run rate = Total actuals / # of days in month
I am running into an issue with the Actual run rate as i want to compare partially completed months to the partially completed number of days. Currently '# of days in month' is stored in a file which i can use to calculat the bugdet run rate
to calculate the actual run rate i am checking whether the month is current if so divide by the(numer of days -calculated measure) otherwise use the run rate actual based on the completed month
When i bring the fields down for the partial month i see the number of days and i see the total actuals but the calculation is not correct
Measure2 is my calculatedfield based on the logic above (however it is showing up the same as total Tons (Actuals)
Hello @Anonymous,
How are these two tables related? What is the calculation for Tons?
Can you share the sample data file for this?
Cheers!
Vivek
https://www.vivran.in/
Connect on LinkedIn
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
7 |