Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

MAX & Filter

Dear all, I have a table with data from different stores and also dates of these data. I now want to include a new column (lastest Data date) which contains an X if this row is the latest data for ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    You can create a calculated column as below:

    Latest data Date = 
VAR _latestDate =
    CALCULATE (
        MAX ( 'Store'[Date] ),
        FILTER ( 'Store', 'Store'[Store] = EARLIER ( 'Store'[Store] ) )
    )
RETURN
    IF ( 'Store'[Date] = _latestDate, "X", "-" )

    Best Regards

    Rena

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous you can add a new column using the following expression

 

LatestDate = 
VAR __latest = CALCULATE ( MAX ( Latest[Date] ), ALLEXCEPT ( Latest, Latest[Store] ) )
RETURN
IF ( __latest = Latest[Date], "X" , "-" )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡