topic fillter result by date for lastdate in DAX Commands and Tips

fillter result by date for lastdate

islam_zaki — Fri, 30 Apr 2021 13:05:19 GMT

Hi All

I need to get only the last sales date as one date, now this DAX :

LastDate NetSales = CALCULATE([Sales ExVAT/ExCHARITY],LASTDATE(SALESTRANSACTION[SALES DATE]))

Giving the last date of each store, may this date have no sales for some stores.

example :

Thanks in Advance...

Re: fillter result by date for lastdate

amitchandak — Fri, 30 Apr 2021 13:33:19 GMT

islam_zaki , You have to try something like

Measure =
VAR __id = MAX ('Table'[Store] )
VAR __date = CALCULATE ( MAX('Table'[Date] ), ALLSELECTED ('Table' ), 'Table'[Store] = __id )
CALCULATE ( sum ('Table'[sales] ), VALUES ('Table'[Store] ),'Table'[Store] = __id,'Table'[Date] = __date )

Re: fillter result by date for lastdate

islam_zaki — Fri, 30 Apr 2021 21:55:03 GMT

amitchandak Thanks for supporting,

i try the above measure but its fail as below :