PowerBI new column calculation based on columns from different tables

Question

I am trying to calculate 'TimeSheet Team PV'[Time (h)] * 'Position History'[Salary]

Data model: TimeSheet Team PV" table: "Position History" table:

In the Position History table, I have some employees which were promoted and appear as having different periods during different periods in the company, with different salary. Can I join somehow these values based on Start Date, End Date (Position History table) and Work Date (TimeSheet Team PV tables) + Name?

I would like to generate new column in the TimeSheet Team PV table, with the calculation above.

Alexis Olson · Accepted Answer · 2020-11-09 20:29:05Z

1

You'll need to write some logic to make sure it uses the Work Date column. Something like this:

Cost =
VAR WorkDate = 'TimeSheet Team PV'[Work Date]
RETURN
    'TimeSheet Team PV'[Time (h)]
        * CALCULATE (
            SELECTEDVALUE ( 'Position History'[Salary] ),
            'Position History'[Start Date] <= WorkDate,
            'Position History'[End Date] >= WorkDate
        )

answered Nov 9, 2020 at 20:29

Alexis Olson

40.4k8 gold badges51 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alexis Olson Over a year ago

In that case, please accept the solution to mark it as resolved.

Collectives™ on Stack Overflow

PowerBI new column calculation based on columns from different tables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related