Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to add a calculated column for the last year sales for the same month divison wise?
DivDateSales
A | 01/01/2015 | 100 |
A | 01/01/2014 | 200 |
A | 01/01/2016 | 300 |
B | 01/01/2015 | 150 |
B | 01/01/2014 | 250 |
B | 01/01/2016 | 350 |
Solved! Go to Solution.
hi @Deva002
try with this:
LastYearSales = CALCULATE(Sum(Sales[Sales]),ALLEXCEPT(Sales,Sales[Div]),DATEADD(Sales[Date],-1,YEAR))
hi @Deva002
try with this:
LastYearSales = CALCULATE(Sum(Sales[Sales]),ALLEXCEPT(Sales,Sales[Div]),DATEADD(Sales[Date],-1,YEAR))
Thanks Victor. 🙂
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |