Forum Discussion
DAXRichArd
Resolver I
Resolver IInquiry: De-normalize data to create dimension tables: what are your best practice recommendations?
Software: Microsoft Power BI - Power Query Editor Hello, I'm looking for recommendations on best practice to de-normalize data in Power Query Editor. Desired outcome: create dimension tables to u...
Hi DAXRichArd - they are all good approaches. Other options to consider are:
- Group By (Table.Group - PowerQuery M | Microsoft Learn)
- Put the table in an Excel file or Sharepoint instead of option 1