Need a calculated column to flag the most recent transaction on the sample table below, desired output will be the last column(TRANSACTION STATUS).
Unfortunately I need to keep all the rows for reference so removing the duplicates based on PAYMENT REFERENCE column is not an option.
Many thanks in advance for all the help.
Go to Solution.
to create a calculated column you can use this DAX statement
CALC Transaction Status =
var currentDate = 'Table1'[TRANSACTION DATE]
IF(MAX('Table1'[TRANSACTION DATE]) = currentDate, "CURRENT", "PREVIOUS")
The underlying assumption is that there are no two or more dates for a Payment Reference with the same date value.
Hope this is what you are looking for
View solution in original post
Thanks a lot!!!
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!