Forum Discussion
Get First and Last Rows with all Columns
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
Thanks. I might have failed to explain. I need to get all the columns and only first and last row by category based on the date (first and lastest)
I made another attempt through an identifier column. Not sure if this is most appropriate way, although, I do get the empty row on top which I suppose I can filter out.
Identifier =
IF (
MIN ( Sheet1[Date] ) = Sheet1[FirstTransactionDate],
"First Test",
IF (
MAX ( Sheet1[Date] ) = Sheet1[LastTransactionDate],
"Last Test",
BLANK ()
)
)This attempt also give the wrong sum for score columns
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