Forum Discussion

Daretoexplore's avatar
Daretoexplore
Icon for Advocate I rankAdvocate I
7 months ago
Solved

Random question

Hi all   I have a weird situation, and Im not sure how to tackle it.   My data is as follows:   Name.                Category.        Date Anne Other.        Banana.          1st Feb Anne Oth...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    7 months ago

    You could create a calculated column as below:

    Is Latest Row =
VAR CurrName = 'Table'[Name]
VAR CurrCat  = 'Table'[Category]
VAR CurrDate = 'Table'[Date]
VAR MaxDateForPair =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Name] = CurrName && 'Table'[Category] = CurrCat
        )
    )
RETURN
IF ( CurrDate = MaxDateForPair, 1, 0 )
krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
7 months ago

Hi Daretoexplore 

 

I have tried with calculated column from sample data. Can you give a try from the image and confirm. Thank You!