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 |
|---|---|
| 55 | |
| 37 | |
| 23 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 58 | |
| 39 | |
| 21 | |
| 21 |