Calculate a Date Difference

[kcantor]

I am trying to calculate a difference in an order date and a conversion date. These dates are pulled from different tables into a single matrix. Generally, BI offers suggestions to help gather data but this time, BI is strangely quiet. My attempted DAX is similar to "Days to Convert = DateDiff('Table1'[Orderdate], 'Table2'[DateConverted, DAY)" any assistance is greatly appreciated. I am still fairly new to DAX in BI.

If necessary, I do have a DimDate table to use.

[antonny999]

Hi 

Currently i use direct query on my server database, which i have a date field that currently already at the DATE format.

which is the format is (dddd, MMMM dd, yyyy)

the detail data have different date but in the same month, i dont know why the display between axis and value is not above the X axis.

i think its because the data have different date. 

can you tell me how to fixed it?

thank you for your support

[kcantor]

Well, yes and no. there are other questions regarding the same DAX. What I was not as clear about as I intended to be is the fact that when I am trying to enter the measure, BI isn't recognizing my table references. Even when I key them in, it will not pull the information but it also doesn't offer any help as far as suggestions for table names or columns through autofil.

[Seth_C_Bauer]

ah, I understand now. Yeah, I see the same odd behavoir. On some calculations (Sum, AVERAGE) etc, the autofill works, and in other cases it isn't... odd

[DamienW]

Old thread I know, and there doesn't seem to be an update? 

I am coming across the same issue, where PBI doesn't seem to allow me to use different table references for each value.  Even when I write them in myself, it doesn't seem to recognise them at all? 

Is this a limiation of PBI?

[DamienW]

Actually I tried combining datediff with related, and it seems to work, try something like:

Days to Convert = DateDiff('Table1'[Orderdate], related('Table2'[DateConverted), DAY)"

See how that goes?

[Seth_C_Bauer]

@kcantor I believe you are asking the same as a couple other threads already have...

see here