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.
Hi
Is there a way for me to calculate the difference between averages on the below senario ?
I have 4 groups (0-3 Days, 4-7 Days, 8-14 Days and 15+ Days) - I want to calculate what the difference between any specified group is - so example difference between Avg 0-3 Days and Avg 4-7 Days will be on first line -543 etc - how do I write the dax measure/column to calculate this difference ? even if I have to have multiples that is fine as long as it gives the correct difference ?
Solved! Go to Solution.
hi again,
Please look at this pbix example in the following LINK
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Hi - I need to show the difference between the different categories so I can show the lost/gained savings on each category and then when they move a certain % over to a selected one what the difference will be
Hello again NadiaLR1234
Can you share a draft of the pretended output
The 4 groups are column in the model?
we need to do all difference ?
BR
Bruno
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Something like this ?
hi again,
Please look at this pbix example in the following LINK
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Thank you will try it this way
Hello NadiaLR1234,
You need to create independent measures, but why do you need all the difference?
It will be some measures, and how the values must appear to the users?
How the total will work?
Why not to expose this information in a visual / graph that explain to users the up and down of values.
BR
Bruno
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
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 |