Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Replace Values from Different tables

Hey Guys,   I need help with this query in M-code. I have one table which has general data and is quite big and slow (Table1). I also have another table which has newer data, fast and shiny (Tab...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your answers.

I need a solution directly in M with a query in the end as I do this in Power BI Dataflows and need a data table like Table3.

Any suggestions in M?

Thanks! 🙂

NickolajJessen's avatar
NickolajJessen
Icon for Solution Sage rankSolution Sage
4 years ago

Just pivot table2 it back to original format 🙂

Add this to the last step on table 2:

 

= Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[Attribute]), "Attribute", "Value")