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")