Posted inDynamics NAV & BC Tips & tricks

The Order You Select Columns In The Power Query Editor Can Affect The Output Of Some Transformations

Maybe this is obvious to more experienced Power Query users, but something I always point out when I’m training people up on Power Query is that the order that you select columns in the Power Query Editor window (both in Power BI Desktop and Excel) can affect the output of certain transformations.

Bron : Chris Webb’s BI Blog
Lees meer…

Gerelateerde artikelen:

  1. Making Sure All Columns Appear When You Combine Data From Multiple Files In Power BI/Power Query M
  2. Adding Tooltips To Column Headers In The Power Query Editor In Power BI And Excel
  3. Removing Punctuation From Text With The Text.Select M Function In Power BI/Power Query/Excel Get&Transform
  4. Improving The Performance Of Aggregation After A Merge In Power BI And Excel Power Query/Get&Transform
  5. Dynamic Column Selection In Custom Columns In Power BI/Power Query/M
Tags: