Creating a column on table that contains only certain values based on another column on that table

Data structure in SQL Table

CalendarDate Year Month EmployeeId PayrollCategoryId PayrollComponentId Category Component USDAmount
1/31/2019      2019 1         82                2                            81                               Earnings  Salary          3793.15
1/31/2019 2019 1 82 2 82 Earnings Commission 3741.00
1/31/2019 2019 1 82 2 86 Earnings TaxablePay 7534.15
1/31/2019 2019 1 82 5 95 Employer Liabilities ErNI 917.22
1/31/2019 2019 1 82 5 96 Employer Liabilities PenEr 84.97

And the resulting table in Power Bi

EmployeeId Salary    Commission Taxable Pay
82                3793.15 3741.00         7534.15