Forum Discussion

ConorHG's avatar
ConorHG
Helper I
8 years ago
Solved

PowerBI ordering Dates

Hi,    I have two columns an Admission Date and a Discharge Date.    I am trying to do a datediff() between the two columns but I have noticed in the data view that every row of the two columns a...
Need Help
  • ConorHG's avatar
    ConorHG
    8 years ago

    Hi All, 

     

    Thanks for replies and sorry for the delay in replying. 

    Managed to resolve the issue.

     

    PowerBI was automatically formatting the columns as DateTime fields but when I converted them to Date fields (as a new step) 

    this seemed to resolve the issue. 

     

    Thanks, 
    Conor.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi ConorHG,

What formula do you use, please share the screenshot as parry2k posted for further analysis.

Best Regards,
Angelia

  • ConorHG's avatar
    ConorHG
    Helper I
    8 years ago

    Hi All, 

     

    Thanks for replies and sorry for the delay in replying. 

    Managed to resolve the issue.

     

    PowerBI was automatically formatting the columns as DateTime fields but when I converted them to Date fields (as a new step) 

    this seemed to resolve the issue. 

     

    Thanks, 
    Conor.