Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |