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 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.

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

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

    see here

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

  • antonny999's avatar
    antonny999
    New Member
    9 years ago

    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