Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I'm trying to create a DAX measure for the previous month or year sales, but it keeps throwing the following error:
If I replace MONTH by YEAR it gives me the same error, only then it says the syntax for YEAR is incorrect. What's wrong here?
Solved! Go to Solution.
@MarnikV Oddly enough, don't use all caps. Use Year and Month as YEAR and MONTH mean different things.
Proud to be a Super User!
Maybe put ;Month instead of ,Month.
Can't believe I missed that... Thanks!
But now it doesn't return anything? Looks like the values of Total Revenue LY are null...
| User | Count |
|---|---|
| 50 | |
| 36 | |
| 29 | |
| 18 | |
| 17 |
| User | Count |
|---|---|
| 66 | |
| 58 | |
| 40 | |
| 21 | |
| 20 |