Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I want to compare the sales Month vs LY Month. It is fine with the non-current month, but for current month, it will only show the result upto same date last year. Is there anyway to show the last year full month sales ?
I tried below, but also cant get the result.
LY Sales = CALCULATE(SUM(Sales[SalesRetailValue]),SAMEPERIODLASTYEAR(ENDOFMONTH(DimDate[FullDate]))) LY Sales = CALCULATE(SUM(Sales[SalesRetailValue]),SAMEPERIODLASTYEAR(DimDate[FullDate]))
Would like to get help from the expert.
Thank you in advance!
Solved! Go to Solution.
User | Count |
---|---|
85 | |
75 | |
73 | |
70 | |
57 |
User | Count |
---|---|
98 | |
97 | |
92 | |
78 | |
70 |