Forum Discussion
How to sort data based on date
But in that case wouldn't it just sort by Descending date?
I apologize for the questions, but I want to better understand to help you properly.
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/
Hello, how are you?
I don't know if it's your case.
But if you have a date table and it is correctly related to your fact table.
Just go to Power Pivot, select your date table and sort the name of the month based on the numeric month column.
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/
This is different from what i want to do, i dont have date table , but i do have table (fact) that has date column and another table (dim) that has the product ID. so i wanted to sort prodct ID based on the date
Could you share a sample of your data.
Or a fictional base.Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/Here, D is the date column, and P, is the product ID, in this screenshot, i would like say the 1/12/20 date and the product ID,s ending with 791 to be at the top
I understood.
My question is what would be the criterion that you will adopt based on the data to consider 139791 and 12/01/20 as the first item on the list.
After knowing this sorting logic, we have a route to follow.Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/