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 need to compare a result of a project that changes almost every day. However, we can have some day with no changes and therefore with same result as previous day. But the source system gives me the figures as below, just showing the days that had variances. So I need to have a measure as column Var below.
Can you please help me?
Thanks!
Date | Result | Var |
01/01/2019 | $ 150,052 | $ 0 |
02/01/2019 | $ 148,041 | $ -2,011 |
04/01/2019 | $ 151,052 | $ 3,011 |
06/01/2019 | $ 150,850 | $ -202 |
Solved! Go to Solution.
@Anonymous
You may check if the following post helps.
@Anonymous
You may check if the following post helps.
Sorry i don't quite understand. Please can you paste a screenshot from excel of the output table you would like? Also if you could upload your pbix file to https://uploadfiles.io/ that would make life easier 🙂
Thanks,
CM
Hi CM.
Sorry for late replied. I tried by myself but no success.
I have uploaded the pbix file in the link below. As you can see, I want to compare the Difference per day and per week. And then, show the accounts for this variance: if was related to cost or revenue.
I really appreciate your help.
Thanks!
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |