Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a column with 'recieved month number' and I'd like to find a way to start my first month at number 7.
I thought about a formula to add 6 to any value less than 7 and subtract 6 for any value greater than.
I tried a table with an index colum but that didnt seem to work. Trying to avoid going down the date path!
Thanks
Nic
Hi @Anonymous ,
Create new column:
MONTH FILTER = IF( MONTH >= 7 , 1 ,0 )
Then, you can filter your visuals with this column. Or create a new table with DAX with with filter MONTH FILTER = 1
Let me know if that was helpful
Cheers
Robin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |