Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 Billing Month.
Without selecting Billing Month Error Message: A table of multiple values was supplied where a single value was expected
2nd approach:
Its not working since i have to use month as one of my parameter.
How can I modify the code so that I can have a full picture without selecting Month.
Thank you for your help.
Sammy Chu
Solved! Go to Solution.
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.
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |