Forum Discussion

dcheng029's avatar
dcheng029
Icon for Helper II rankHelper II
2 years ago
Solved

How to create calculation from two data sources on Power BI?

Hi team,   I am working with two data sources simplified to the below example:   Data Source 1 Name Team Control 1 Control 2 Control 3 Control 4 John Smith A C C   C Bob Will ...
Need Help
fahadqadir3's avatar
fahadqadir3
Icon for Solution Supplier rankSolution Supplier
2 years ago

dcheng029First You need to Unpivot your Data Source 1.
In Power Query, Select the Control 1 to Control 4 columns.
Right-click and choose Unpivot Columns.
Rename the columns appropriately (Control and Competence)

Review the attached screenshot and pbix file. 

Controls.pbix

 

Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!! 

 

dcheng029's avatar
dcheng029
Icon for Helper II rankHelper II
2 years ago

Hey fahadqadir3,

Thanks for the information and assistance!

I tried to follow the measures from Shivu-2000's below comment as well as your tip to unpivot the controls columns, however when I create the table visual the numbers of Competent Controls Conducted and Incompetent Controls Conducted all seem incorrect (I am working with my true dataset which has a lot more entries within both data sources however the logic is still all the same).

 

Any ideas on where I have gone wrong?