Forum Discussion

HYEasterly's avatar
HYEasterly
Icon for Helper I rankHelper 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.

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
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.