Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
His calendar is awesome, but I can't get it to sort by quarter. His videos mention to sort Month by the monthnum column, but what should I sort the Quarter column by?
Solved! Go to Solution.
Hi @tomwynn ,
It seems the Quarter column is text type in the video. How about change the Quarter column to the number type?
Please try to the following column.
Quarter column=Right('table'[Quarter],1)
Then you can sort it now.
If it still does not help, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tomwynn ,
It seems the Quarter column is text type in the video. How about change the Quarter column to the number type?
Please try to the following column.
Quarter column=Right('table'[Quarter],1)
Then you can sort it now.
If it still does not help, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.