Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
qhpowerbi
Helper III
Helper III

Add New Row which the result of division other row in Power Query

‎12-29-2022 11:02 PM

Hi all,

I have a table in Power Query which source from other Database as below with Veggie and Milk the main table. I would like to add new row to power query table which is the result of division row Veggie and Milk (as highlighted in Red). Anyone can help me with this? Thanks in advance!

qhpowerbi_0-1672383662928.png

 

 

Labels:
Message 1 of 3
243 Views
0
1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

‎12-29-2022 11:24 PM

hi @qhpowerbi 

try to 

1) transpose the table

2) add a custom column with [Viggie]/[Milk]

3) transpose back

 

about PQ transpose:

https://learn.microsoft.com/en-us/power-query/transpose-table

 

View solution in original post

Message 2 of 3
206 Views
2 REPLIES 2
qhpowerbi
Helper III
Helper III

‎12-30-2022 02:40 AM

This is brilliant! Thank you

Message 3 of 3
186 Views
0
FreemanZ
Super User
Super User

‎12-29-2022 11:24 PM

hi @qhpowerbi 

try to 

1) transpose the table

2) add a custom column with [Viggie]/[Milk]

3) transpose back

 

about PQ transpose:

https://learn.microsoft.com/en-us/power-query/transpose-table

 

Message 2 of 3
207 Views

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All