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?
Go to Solution.
Proud to be a Super User!
View solution in original post
@Pikachu-Power , try like
CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = lastdate(Table1[Date] ))
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.