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.
Hello,
I have data that show the actual sales and the budget for each month. Each line is the data is for the full month, not indivudal days.
I am ususing a gauge chart and I want a target figure of sales pro rata. So total budget divided by 365 to give me a day target. Then take that day target and multiply by the day of the year for example today 31st may is the 151st day of year
Im not sure how to do this, if it shoudl be a measured column or something else?
Solved! Go to Solution.
Hi kporteous,
Create a calculate column using DAX formula like this pattern:
result = SUM ( table[budget] ) * table[date] / 365
Regards,
Jimmy Tao
Hi kporteous,
Create a calculate column using DAX formula like this pattern:
result = SUM ( table[budget] ) * table[date] / 365
Regards,
Jimmy Tao
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |