I’m trying to calculate the last Sale Amount in a Sales Table. (See screenshot of my model below) My measure is as follows;
Last Sale Amount = CALCULATE( [Total Sales] , LASTNONBLANK( Dates[Date] , [Total Sales] ) )
I get $0. As well for the Last Sale Date I get the last date in my Date Table. So it seems my relationships are not working correctly.
The moment I make the Date and Invoice tables bi-directional it works. But then breaks alot of my other measures with below screenshot errors.
Any help would be great.