Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to convert month numbers to names, this is what i tried:
Short Month = SWITCH ( 'YM'[Month]; 1, "Jan"; 2, "Feb"; 3, "Mar"; 4, "Apr"; 5, "May"; 6, "Jun"; 7, "Jul"; 8, "Aug"; 9, "Sep"; 10, "Oct"; 11, "Nov"; 12, "Dec"; BLANK () )
However it gives me a "syntax incorrect" for every month name. Anyone know why this is?
Solved! Go to Solution.
Should be all commas or all semicolons depending on your version
Should be all commas or all semicolons depending on your version
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |