Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to sort data based on date

I am trying to sort  data  on my power BI report  based on one column in one table based and  date column from another table in  , i wanted to know if there is a DAX function   for sorting data in th...
Need Help
  • rodrigosan's avatar
    rodrigosan
    4 years ago

    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/

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 

rodrigosan's avatar
rodrigosan
Responsive Resident
4 years ago

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/