Can someone please provide me with assistance. I have 2 tables which are joined on a Project # and need to find the number of days between Created On Date and Project Start Date. Below is an example of what I am looking to achive.(Table 1 [Created On]) (Table 2 [Project Start Date])Desired Result1/5/2022 5/5/20221202/18/20223/1/202211 Thanks for any help!

Hi rohit_singh Thanks for your help, but please check your solution suggetion ..... var _datediff = DATEDIFF('DatesBetween'[CREATED_ON],'DatesBetween'[PROJ_ST_DT],DAY) Wont the DatesBetween'[CREATED_ON] return a buggy table value ? 🤔 You need to wrap it in a SELETEDVALUE, MIN or MAX to get a scalar value. See method I suggested. Many thanks 😎

Calculate days between dates in different tables

Forum Discussion

Related content

Different Calculations

Dynamic Calculation Different Period

Calculating Differences

How to add two different calculated columns of two different table

1. How to add two different calculated columns of two different table