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.
Good morning,
I think this may be the conversation that drives me to figure out measures. I am trying to get a column to identify the % of "Actual" to "Budget" on the displayed table. Image one is the PBI dashboard and image two is the table I am pulling it from. Looking for direction on either how-to or where to learn how-to.
Thank you kindly fellow data friends.
Kondukt
Solved! Go to Solution.
Hi @Miskondukt,
Based on my understanding, your desired output is adding an extra column beside [Budget] to show the percentage value (Actual/Budget), right?
I have uploaded a pbix file (a test based on your sample data) for your reference. Also, you can go through my reply in this thread which described a similar request: Variation estimated vs. real
Best regards,
Yuliana Gu
Hi @Miskondukt,
Based on my understanding, your desired output is adding an extra column beside [Budget] to show the percentage value (Actual/Budget), right?
I have uploaded a pbix file (a test based on your sample data) for your reference. Also, you can go through my reply in this thread which described a similar request: Variation estimated vs. real
Best regards,
Yuliana Gu
Hi What happen if you use:
%ActualvsBudget=Divide(Sum(Table[Actual]),Sum(Table[Budget]),Blank())
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 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |