Forum Discussion
Counting stores where sales within date range
HI, I have stores that sale items and I need to find last sale per store within selected (calendar) date range. Sale date is related to calendar date. I want to get one row per StoreID with latest s...
I solved this, solution is to create Summary table using SUMMARIZE, like
SUMMARIZE(tblSales, [StoreID], CALCULATE(MAX(Saledate),Sales[TotalPaymentsRunningTotal]>0))