Forum Discussion
Pikachu-Power
Impactful Individual
Impactful IndividualCALCULATE with LASTDATE
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?
- VAR LD = CALCULATE(LASTDATE(Table1[Date]),Table1[Part] <> "B")
RETURN Number = CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = LD)
2 Replies
- Greg_Deckler
Community Champion
VAR LD = CALCULATE(LASTDATE(Table1[Date]),Table1[Part] <> "B")
RETURN Number = CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = LD) - amitchandak
Super User
Pikachu-Power , try like
CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = lastdate(Table1[Date] ))
