Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX Date Function (Datediff) cross table

Hi there,   I have two tables as sources in my report. Now I want to use datediff function on two dates one located in on the other in the other table. Somehow it doesnt seem to support this.    ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous  is it one to many relationship? if yes, you can use RELATED function to get date from one side of table relationship.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k Hi there, yes it is a one to many relationship. How will then the syntax look like in my example?

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      Anonymous  try following, assuming table2 is on one side of the relationship.

       

      Days Subscribe/Book = DATEDIFF(Table1[dateCreated];related(Table2[Opt-in time]);day)
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi parry2k 

         

        Days Subscribe/Book = DATEDIFF(Subscriber[CONFIRM_TIME];related(Buchungen[dateCreated]);day)
         
        This is the formula that I ended up with however PowerBi comes up with an error saying that column Buchungen(dateCreated) is not found or not related to a table in this context. 
        What can be the reason? pls. find the relation  setting below (sorry it's german)
         
        Thx Florian