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
danextian's avatar
danextian
Super User
1 year ago

Hi LearnerMM 

 

By "manage relationship" you mean there is a direct relationship between the two tables or is there a dimension table in between? Which one's on the many side? Which one's on the one side? Some functions will work depending on which side of the relationship the table is? Please show your diagram.

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!