Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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())
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |