Forum Discussion

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
10 years ago

Calculate a Date Difference

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 b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

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's avatar
DamienW
Frequent Visitor
9 years ago

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's avatar
    DamienW
    Frequent Visitor
    9 years ago

    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?