cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gilsonshinkawa
New Member

Calculating percentage in a row

Hi Everyone,

I would like help in calculating percentage in a row.MatrixValues.png

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:%.pngI 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.

 

Thanks,

Gilson Shinkawa

 

 

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft
Microsoft

Hi @gilsonshinkawa,

 

Based on my assumption, the table structure is like below, if so, please add a calculated column to list the percentage.

1.PNG

Percentage =
Sheet1[Value]
    / CALCULATE (
        MAX ( Sheet1[Value] ),
        FILTER (
            ALLEXCEPT ( Sheet1, Sheet1[Date] ),
            Sheet1[Date2]
                = CALCULATE ( MIN ( Sheet1[Date2] ), ALLEXCEPT ( Sheet1, Sheet1[Date] ) )
        )
    )

2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft
Microsoft

Hi @gilsonshinkawa,

 

Based on my assumption, the table structure is like below, if so, please add a calculated column to list the percentage.

1.PNG

Percentage =
Sheet1[Value]
    / CALCULATE (
        MAX ( Sheet1[Value] ),
        FILTER (
            ALLEXCEPT ( Sheet1, Sheet1[Date] ),
            Sheet1[Date2]
                = CALCULATE ( MIN ( Sheet1[Date2] ), ALLEXCEPT ( Sheet1, Sheet1[Date] ) )
        )
    )

2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!