Forum Discussion

HYEasterly's avatar
HYEasterly
Helper I
1 year ago
Solved

Power BI Dax Linking data from multiple tables

I'm missing something... and don't know what... I can't get it to give me what I want...   How do I get my table to give me the equipment run time and the billable work for each day and each forema...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    Billable Work (works):

    Billable Work = SUM ( 'Track Invoice'[Billable Work] )


    Run Time (if direct relationships work):

    Run Time = SUM ( 'GPS'[Run Time] )


    If Foreman doesn’t filter GPS → use TREATAS bridge:

    Run Time =
    CALCULATE (
    SUM ( 'GPS'[Run Time] ),
    TREATAS ( VALUES ( 'Track Equipment'[Equipment ID] ), 'GPS'[Equipment ID] ),
    TREATAS ( VALUES ( 'Track Equipment'[Work Date] ), 'GPS'[Date] )
    )

     


    Use the TREATAS version if your runtime doesn’t align with Foreman/Date/Equipment.

danextian's avatar
danextian
Super User
1 year ago

Hi HYEasterly 

 

You've showed the desired result but didn't provide us with a sample data. There's also no mention of how to compute runtime. Your expected result breaks it down by employee but GPS table doesnt have this information.

Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.