Forum Discussion

Mahamood0218's avatar
Mahamood0218
Helper II
4 years ago
Solved

Date difference between two different tables columns

Hi PBI Experts, We have two different tables Tabele1 and Table2 in that table i need find Caluclated Column dax function for  Date diffence between two tables(Joining date and Action date along with...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Mahamood0218 ;

    Try it.

    Diff = DATEDIFF(RELATED(Table1[Joining date]), [Action date],DAY)

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Mahamood0218 ;

Try it.

Diff = DATEDIFF(RELATED(Table1[Joining date]), [Action date],DAY)

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.