Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I hope somebody can help me with this problem.
Why do next year and not last year?
are you trying to get last year sales? it should be something like this.
lastyearsales = CALCULATE ( SUM ( 'tablename'[Sales] ), PREVIOUSYEAR ( 'tablename'[Date] ) )
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |