Forum Discussion
Solved
SPLM data without consider date filter
i have calculate same period last month using the below dax SPL_Month_KG_Card = CALCULATE ( [sales in kg], -- Replace [sales in kg] with the actual measure for sales in kg. DATEADD('G...
Try
Same period last month = VAR ThisMonth = CALCULATETABLE ( DATESMTD ( 'Global Date'[Date] ), TREATAS ( { TODAY () }, 'Global Date'[Date] ) ) VAR Result = CALCULATE ( [sales in kg], DATEADD ( ThisMonth, -1, MONTH ) ) RETURN Result
