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!!!
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.