Forum Discussion
find Date diff from two different tables
Hi all, I am trying to find a DAX to calculate the Datediff between PODATE (from PO table) and INVOICEDATE (from invoice table). The two tables are linked PONUMBER. I have tried date diff = ...
Hi phuynh242
According to your description, it seems that you want to get datediff based on table’s date column. But in your expression, it seems that you are calculating on date and ponumber. You need to use corrected expression. You could create a calculated column in PO table like below
datedif = DATEDIFF ( PO[PODATE], RELATED ( INVOICE[INVOICEDATE] ), DAY )
Best Regards,
Zoe Zhi