Forum Discussion

sanderson82's avatar
sanderson82
Icon for Helper I rankHelper I
7 years ago
Solved

Calculation with columns in different tables

Hi Quite new to Power BI.  I've created a timesheet app in PowerApps and the data is stored on a sharepoint list.  Name, Date, Contract, Hours.  I also have a second sharepoint list holding the empl...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi sanderson82 ,

    Firstly, we can connect to the data using the Sharepoint List connector, then import these two tables to PowerBI, then create a many to one relationship between these tables.

    After that, we can create a measure:

    CALCULATE (MIN('Timesheets'[Hours]) * MIN('Employees'[Rate]))

    This measure will be displayed in the table Timesheet.

    Best Regards,

    Teige

TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi sanderson82 ,

Firstly, we can connect to the data using the Sharepoint List connector, then import these two tables to PowerBI, then create a many to one relationship between these tables.

After that, we can create a measure:

CALCULATE (MIN('Timesheets'[Hours]) * MIN('Employees'[Rate]))

This measure will be displayed in the table Timesheet.

Best Regards,

Teige

sanderson82's avatar
sanderson82
Icon for Helper I rankHelper I
7 years ago

Thanks TeigeGao that is exactly what I was after.  I just have one issue now, do you know how I show the cost as a sum?