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.

parry2k's avatar
parry2k
Super User
8 years ago

caan you share the screen shot? I never seen this, try to refresh data and see if it works.