CALCULATE with LASTDATE

[Pikachu-Power]

Hello,

i try to find a way to integrate LASTDATE in a calculation. A possibility is:

VAR LD = LASTDATE(Table1[Date])

RETURN Number = CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = LD)

The problem is that i dont have the last date considering Table1[Part] <> "B". Some ideas what to adjust?

[amitchandak]

@Pikachu-Power , try like

CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = lastdate(Table1[Date] ))

[Greg_Deckler · Accepted solution]

VAR LD = CALCULATE(LASTDATE(Table1[Date]),Table1[Part] <> "B")

RETURN Number = CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = LD)