Forum Discussion
Direct query, not able to make changes
You can safely add a month number column to either your fact table or your calendar table (I'd recommend the calendar table) in Power Query using just Date.Month([Date]). This will fold to the server and is, therefore, fine for use in a Direct Query model.
Once you have that column, you can select your month name column in the Modelling tab, and use the 'Sort by column' dropdown under Advanced settings to assign it to sort by Month number:
Pete
Thank you! The dataset is indeed way to big to be imported. I already have a date/calender linked to many visuals, but like I mentioned- it's not really doing its job well.
My question was more if I can avoid making a whole new table and linking the new stuff to all the visuals or if i have no other choice.
You can safely add a month number column to either your fact table or your calendar table (I'd recommend the calendar table) in Power Query using just Date.Month([Date]). This will fold to the server and is, therefore, fine for use in a Direct Query model.
Once you have that column, you can select your month name column in the Modelling tab, and use the 'Sort by column' dropdown under Advanced settings to assign it to sort by Month number:
Pete