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  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
  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous,

     

    By my tests, I cannot reproduce your issue.

     

    If it is convenient, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Best Regards,

    Cherry