Solved: How to pull the column name in a row and their res...

Anonymous · ‎12-17-2020

Hi everyone, I have got one table that contains some values. I want to create another table with certain conditions from the first one. I have attached a picture with a question and an expected solution. Is there any way we can do this? Looking for help. thank you

mahoneypat · ‎12-17-2020

In the query editor, highlight your ID colum, right click and choose unpivot other columns.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

amitchandak · ‎12-17-2020

@Anonymous , Unpivot the the table and they filter non zero values in in power query

https://radacad.com/pivot-and-unpivot-with-power-bi
https://www.youtube.com/watch?v=2HjkBtxSM0g

to remove

https://community.powerbi.com/t5/Desktop/M-Power-Query-Removing-entire-rows-based-on-condition/td-p/367563

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!