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/

rodrigosan's avatar
rodrigosan
Responsive Resident
4 years ago

Create a custom column in Power Query:

= Table.AddColumn(#"Changed Type", "KeyId", each Text.Combine({Date.ToText([Date], "yyyy"), Date.ToText([Date], "%M"), Date.ToText([Date], "dd")}), type text)

then set this column as number:

 

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

I tried this code and my column shows "table" 

 

--here is my code 

Table.AddColumn(#"Changed Type", "KeyId", each Text.Combine({Date.ToText([orderdate], "yyyy"), Date.ToText([orderdate], "%M"), Date.ToText([orderdate], "dd")}), type text)