cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adelmonte
Resolver I
Resolver I

Get percentage of total in Power Query

Hi all,

I need a help with percentage calculation from total.
I manage to do it in Excel, but I can't do it in Power Query.
All tips are welcome.

 

adelmonte_0-1652716708817.png


Thanks,

Alex

1 ACCEPTED SOLUTION

Hi Speedramps,
Thanks for the reply.
I apologize for the previous post description is not clear, and it can be deleted as it is of no use.
Thanks,

Alex

View solution in original post

2 REPLIES 2
speedramps
Super User
Super User

We want to help you but this description looks a bit rushed, you will get a faster response if you take time. ☹️

 

Please provide example input data (as tables not screen shots , so we can import them and develop solutions)

 

Please also provide example desired output data.

 

Give a clear description of the process.

 

Are you usure you want % as a Power Query column and not a data measure ?  That seem like an odd request 

 

Thanks.

 

 

Hi Speedramps,
Thanks for the reply.
I apologize for the previous post description is not clear, and it can be deleted as it is of no use.
Thanks,

Alex

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors