Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

transforming excel sheet in power query editor

I am new to power query editor. I have an excel sheet with three columns, Notification, Stat., and Date. Each column has 1311 rows. I want the notification column to stay where it is. I need all 1311...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

I'm reasonably sure you don't really want to do this (in power query at least).

If you did do it and if you want do anything with those new columns, you'll have to write a measure for each column => 1311 measures.

Also, what happened to row with Notification 300642957?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HotChilli,

     

    The row with notification 300642957 would be moved below the first notification. Atleast, that is what my boss wants. 

    NotificationE0002E0042
    300540151/24/202401/17/2024
    3006429575/22/20241/5/2024


    What does it mean to write a measure for each column?