I would like help in calculating percentage in a row.
If you see in the image i made this matrix using month and year, i would like to make same matrix but using percentage.
Example in excel:I want divide each value in the collumn by the first value in the row. I dont know if i was clear.
Can anyone help me do this in Power BI.
Go to Solution.
Based on my assumption, the table structure is like below, if so, please add a calculated column to list the percentage.
/ CALCULATE (
MAX ( Sheet1[Value] ),
ALLEXCEPT ( Sheet1, Sheet1[Date] ),
= CALCULATE ( MIN ( Sheet1[Date2] ), ALLEXCEPT ( Sheet1, Sheet1[Date] ) )
View solution in original post
Hi @v-yulgu-msft!Thanks for the help!It worked here!Could you help me in another one?It's kind similar of this problem.I'll open another post.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!