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/
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/Beacuase thats the newest date , it should be at the top
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/