Forum Discussion

JonathanHall's avatar
JonathanHall
New Member
2 years ago
Solved

Using Power Query to group data into unique values and to simplify layout

Hi, I'm wondering whether I use Power BU or Power Query for this problem?  I can solve the problem in excel, but the raw data is huge (c500,000 records) and excel gets cumbersome when handling this a...
  • lbendlin's avatar
    2 years ago

    No need to do anything. Load your data as is, and then use a Matrix visual. UPRN on rows, Operator on columns, Speed on values.