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))
