Forum Discussion
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 this way
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/
13 Replies
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/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/
What you will have to do is create a column that transforms the date into numeric code and sort by it.
12/01/2020 = 20201201
Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/