i need a table of sql results transposed. First column needs to become column headers

I need to use Unpivot and Pivot functions. I have the query to pull the results, but transposing in PowerBI will not allow model to be dynamic as the first column will change every month.