I've been trying to create a formula to relate data to the last month in DAX. Nothing I've found or created has worked.
What I've Tried:
CALCULATE(
SUM('Data Warehouse'[EXT AMOUNT]),
--VALUES('Data Warehouse'[EXT AMOUNT]),
----------
--PREVIOUSMONTH(ALL('Dates'[Dates]))
PARALLELPERIOD(ALL('Dates'[Dates]),-1,MONTH)
--DATEADD('Data Warehouse'[Sale.Invoice Date],-1,DAY)
--DATEADD(DATESMTD('Data Warehouse'[Sale.Invoice Date]),-1,MONTH)
--FILTER(
-- ALL('Dates'[Dates]),
-- EARLIER('Dates'[Index]) = 'Dates'[Index]-30
--)
)
I've tried all of these. The only one that doesn't return blank data is PARALLELPERIOD, and it returns the same data as EXT AMOUNT.
What I've Tried:
CALCULATE(
SUM('Data Warehouse'[EXT AMOUNT]),
--VALUES('Data Warehouse'[EXT AMOUNT]),
----------
--PREVIOUSMONTH(ALL('Dates'[Dates]))
PARALLELPERIOD(ALL('Dates'[Dates]),-1,MONTH)
--DATEADD('Data Warehouse'[Sale.Invoice Date],-1,DAY)
--DATEADD(DATESMTD('Data Warehouse'[Sale.Invoice Date]),-1,MONTH)
--FILTER(
-- ALL('Dates'[Dates]),
-- EARLIER('Dates'[Index]) = 'Dates'[Index]-30
--)
)
I've tried all of these. The only one that doesn't return blank data is PARALLELPERIOD, and it returns the same data as EXT AMOUNT.