Forum Discussion
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(...
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.
Regards,
Xiaoxin Sheng
smerchant issue with your question is to get all columns in a row, it is possible to get a column, not a problem, and you have to perform the same calculation for all the columns.
Thanks. Even if you have 20 columns? is it possible to create a seperate table based on the condition/filter which gets updated?
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.
Regards,
Xiaoxin Sheng