Forum Discussion

smerchant's avatar
smerchant
Helper I
7 years ago
Solved

Get First and Last Rows with all Columns

I have data something like this and I want get the first and last rows based on the date: I created some measure for example like InitialScore, LastScore, FirstDate...:  InitialScore = MINX(...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI smerchant ,

    You can consider to do unpivot columns on your fields, then you can simply write formula to calculate first/last records based on original category and attribute group.

    Unpivot columns (Power Query)

    Regards,

    Xiaoxin Sheng

smerchant's avatar
smerchant
Helper I
7 years ago

Thanks.  Even if you have 20 columns?  is it possible to create a seperate table based on the condition/filter which gets updated?

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI smerchant ,

You can consider to do unpivot columns on your fields, then you can simply write formula to calculate first/last records based on original category and attribute group.

Unpivot columns (Power Query)

Regards,

Xiaoxin Sheng