Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
30 | |
15 | |
11 | |
10 | |
9 |