Calculate a Date Difference

Question

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.

anonymous · Answer

kcantor&nbsp;I believe you are asking the same as a couple other threads already have...see here

kcantor · Answer

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.&nbsp;

anonymous · Answer

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 · Answer

Old thread I know, and there doesn't seem to be an update?&nbsp;&nbsp;I am coming across the same issue, where PBI doesn't seem to allow me to use different table references for each value. &nbsp;Even when I write them in myself, it&nbsp;doesn't seem to recognise them at all?&nbsp;&nbsp;Is this a limiation of PBI?

damienw · Answer

Actually I tried combining datediff with related, and it seems to work, try something like:&nbsp;Days to Convert = DateDiff('Table1'[Orderdate], related('Table2'[DateConverted), DAY)"&nbsp;See how that goes?

Forum Discussion

Calculate a Date Difference

Related content

Calculate date difference vs today date

Calculate date difference

Calculate difference between two dates power query

Dynamic Calculation Different Period

Date Different return wrong value