Forum Discussion
Solved
Utilizing Fields from Multiple Tables In a Single Visualisation
Hi, everyone—new user to Power BI here. I've been messing around with it over the last week and have started to get the hang of it pretty well, but I have an target that I'm having trouble hitting. P...
Hi, Create a new Table
Related with your 2 tables
Use a measure:
Percentage of Retainer Hours Billed Externally = DIVIDE ( SUM ( 'External Hours Logged'[Duration Logged] ), SUM ( 'Retainer Hours Assigned'[Retainer Hours] ) )Regards
Victor
Lima - Peru
Hi, Create a new Table
Related with your 2 tables
Use a measure:
Percentage of Retainer Hours Billed Externally =
DIVIDE (
SUM ( 'External Hours Logged'[Duration Logged] ),
SUM ( 'Retainer Hours Assigned'[Retainer Hours] )
)
Regards
Victor
Lima - Peru