Forum Discussion

vckbx's avatar
vckbx
Helper I
5 years ago
Solved

Distinct Count on Last Date

Hi - I have data in this format: Item Party Date 1 A 1/1/2021 2 A 1/1/2021 3 A 1/1/2021 4 A 1/1/2021 1 A 2/1/2021 2 A 2/1/2021 3 A 2/1/2021 4 A 2/1/2021 ...
  • PaulOlding's avatar
    PaulOlding
    5 years ago
    Does this do the job?
     
    LastItems =
    VAR _LastDate = MAX('Table'[Date])
    RETURN
    CALCULATE(
    DISTINCTCOUNT('Table'[Item]),
    'Table'[Date]=_LastDate
    )
PaulOlding's avatar
PaulOlding
Solution Sage
5 years ago
Does this do the job?
 
LastItems =
VAR _LastDate = MAX('Table'[Date])
RETURN
CALCULATE(
DISTINCTCOUNT('Table'[Item]),
'Table'[Date]=_LastDate
)
vckbx's avatar
vckbx
Helper I
5 years ago

That did it! Thanks. Any explanation as to why that works vs my method?