Calculate number of days between 2 dates - Different Table

[gauravnarchal]

Need help!

How can I calculate the number of days between Shipment Date in Table 2 & Invoice date in Table 1?

[v-deddai1-msft]

Hi @gauravnarchal ,

Please create an index column in both tables, and create an relationship between two table by the index column. Then you can use the following dax:

Column = 'Table1'[Invooice Date]-RELATED(Table2[Shipment Date])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[harshnathani]

Hi @gauravnarchal ,

You can check if this helps

https://community.powerbi.com/t5/Desktop/Subtracting-Dates-within-Two-Different-Tables/td-p/398333

https://community.powerbi.com/t5/Desktop/Cross-table-Datediff/td-p/81075

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[amitchandak]

@gauravnarchal , refer this blog - Create a common table and then take diff

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...

This file has 2-3 approaches. Copy data into another table and do it

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

[lousegers]

Hi @gauravnarchal ,

You can create a calculated column. Right click on the table, select "New Column", in the formula section you can use

Column Name = 1. * (Table[actual start date] - Table[target start date])

This should give you the negative number of days between the two dates.

Was my answer anywhere helpful?

Show your appreciation by simply marking my reply as solution or throw it a kudo.

Hop on the data train and get connected @LouSegers