Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Date issue

Hi,   Here is my issue: I am trying to get the difference between two dates (I am using a direct query view), but on PBI desktop, I don’t see my fields as date format: If anyone has any ide...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Amy, but it is "kind of" a format date already but I still cannot use the Dax measure: 

 

 

 

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Based on my test which connect to SQL Server database using DirectQuery Mode in the latest version of Power BI Desktop, the DATEDIFF function works well.

 

 

DateDiff = DATEDIFF(MAX(Sales[CreationDate]),MAX(Sales[ClosureDate]),DAY)

 

 

 

>>Thanks Amy, but it is "kind of" a format date already but I still cannot use the Dax measure: 

 

Is there any error message to appear when you create this measure?

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.