Forum Discussion

kcantor's avatar
kcantor
Community 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
kcantor's avatar
kcantor
Community Champion
10 years ago

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.

 

  • 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?