Forum Discussion

jrpoli2000's avatar
jrpoli2000
Frequent Visitor
8 years ago
Solved

Latest Dates

Hello,   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 ro...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

    to create a calculated column you can use this DAX statement

    CALC Transaction Status = 
var currentDate = 'Table1'[TRANSACTION DATE]
return
CALCULATE(
    IF(MAX('Table1'[TRANSACTION DATE]) = currentDate, "CURRENT", "PREVIOUS")
    ,ALLEXCEPT('Table1',Table1[PAYMENT REFERENCE])
)

    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

     

    Regards

    Tom

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

to create a calculated column you can use this DAX statement

CALC Transaction Status = 
var currentDate = 'Table1'[TRANSACTION DATE]
return
CALCULATE(
    IF(MAX('Table1'[TRANSACTION DATE]) = currentDate, "CURRENT", "PREVIOUS")
    ,ALLEXCEPT('Table1',Table1[PAYMENT REFERENCE])
)

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

 

Regards

Tom

jrpoli2000's avatar
jrpoli2000
Frequent Visitor
8 years ago

Thanks a lot!!!