DATEDIFF in Direct Query Mode (32-bit)

[wuhao0506]

When i try to create a calculated column in the power bi (32-bit) in Direct Query mode. I got error on the dax function.

I went to settings, but i dont see the option and enable unrestricted measures.

Can anyone help on this?

Thanks in advance

[v-yuezhe-msft · Accepted solution]

@wuhao0506,

Do you use Power BI Desktop August version ? Based on mye test, even we enable unrestricted measures, it is not possible to use DATEDIFF function in calculated columns in DirectQuery mode. However, you can create a measure instead.

Measure = IF(MAX('Project-Activity'[PLANNED_START_DATE])<'Project-Activity'[DATADATE],DATEDIFF(MAX('Project-Activity'[PLANNED_START_DATE]),'Project-Activity'[DATADATE],DAY),DATEDIFF('Project-Activity'[DATADATE],MAX('Project-Activity'[PLANNED_START_DATE]),DAY))

Regards,
Lydia

[MarvosR]

I thing this is unnacceptable solution, since making this a calculation will restrict your later transformations. I'm trying for over a week to do this calculation for a calculated column and it seems impossible. Why you do that, Microsoft?