Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Calculated column for number reordering

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

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.