Forum Discussion
Solved
Modifying DAX Code for retrieve full data
Hi there, Below is the sum of Sales with LLM last last month, LM Last Month, TM This Month Hope my result like: 1st approach: Right now i can retrieve the result by selecting Billin...
mSale:=SUM(Sales[sale])
mSalesLM:=CALCULATE([mSale],PARALLELPERIOD('Calendar'[Date],-1,MONTH))
mSalesLLM:=CALCULATE([mSale],PARALLELPERIOD('Calendar'[Date],-2,MONTH))
mSale:=SUM(Sales[sale])
mSalesLM:=CALCULATE([mSale],PARALLELPERIOD('Calendar'[Date],-1,MONTH))
mSalesLLM:=CALCULATE([mSale],PARALLELPERIOD('Calendar'[Date],-2,MONTH))
Hi RichardOfSydney ,
Thank you for your help.
But the LLM get the same result with This month.
Cheers,
Sammy Chu
Dont use the var, they are 3 distinct measures.