Forum Discussion
Date Sort
Hello, I am having trouble sorting the dates Below. I created an additional column based off our Ship date. The column I created is YearMonth(Ship) = 'FBAP Event Detail Fact'[ship_dt].[Year...
Anonymous
Create another column to sort your Year month Column. Select your YearMonth(Ship) column and Click on sort by column and select the following column to sort bySort_YearMonth(Ship) = 'FBAP Event Detail Fact'[ship_dt].[Year] * 100 + 'FBAP Event Detail Fact'[ship_dt].[Month]________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super UserAnonymous
Create another column to sort your Year month Column. Select your YearMonth(Ship) column and Click on sort by column and select the following column to sort by
Sort_YearMonth(Ship) = 'FBAP Event Detail Fact'[ship_dt].[Year] * 100 + 'FBAP Event Detail Fact'[ship_dt].[Month]
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂