You might need to unpivot and pivot again your data if you want to call the descriptions table just once and keep the structure in your results. Here's an example:

Here is a page with 500+ T-SQL puzzles that could help. https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
You could also try to solve problems from the forums which are more focused on...

I don't see how QTD or YTD are measures. They certainly look as calculations done on measures using a time dimension.

Will there only be 2 values or could you have more than 1 alias?

What if we work with some sample data.

CREATE TABLE SolTracker(
    eligibility_flg char(1) NULL
);

CREATE TABLE DutyManager(
    eligibility_flg char(1) NULL
);

INSERT INTO SolTracker...