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
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 🙂
1 Reply
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 🙂