Forum Discussion

LearnerMM's avatar
LearnerMM
New Member
1 year ago

Substract time columns from diff datasets

Dear Mentors,   I need to substarct column "EST Start" from "EST" ...basically trying to calculate delay. "EST" indicates schedule - Source is dataset1 "EST Start"  indicate actual start time - s...
Need Help
LearnerMM's avatar
LearnerMM
New Member
1 year ago

Hey Thanks @danextian  ...... actually problem is - It dose not pull out column name from other datasource.

 

We can substract 2 columns from same data source - but if you try to select another datasource columns , Power BI is not giving me option to select from other datasource. 

 

Can  Iconnect with anyone of you ? 

 

Thanks

Mangesh M

tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

LearnerMM 

Please provide the details of the relationship you created. For example if [EST] column is in Table1 and [EST Start] column is in Table2 and if I assume you created 
One to Many relationship between these two 

Table1 on one side and Table2 on the many side then you can follow this DAX measure syntax 

Delay = SUMX(Table2, Datediff(Related(Table1[EST]),  Table2[EST Start], Minute  ) )

 

Need a Power BI Consultation? Hire me on Upwork

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!