Kindly if someone can help me to figure out a mesure to calculate variance between two columns formated with percentage of total.
My 2 columns E and F are displayed on Powerbi as Percentage of GT
I need to calculate on Power Bi the column G using these percentages of the columns E and F
Thanks in advance for your help
Go to Solution.
Finally I was able to solve this, thanks to the solution posted on the following link https://community.powerbi.com/t5/Desktop/What-is-the-GT-Quick-Calculation-really/m-p/177595#M77682
I used measure to calculate %GT for each column
than another measure to calculate the variance
View solution in original post
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!