[DAX formula] Show value of column head where value not empty

[wech747]

Hi,

I am being challenged by a actual simple looking problem, but so far I am not able to solve it. Now I hope, that you can help me:

To create a line graph, in which the sum of reinvestment costs of devices are shown year by year, I need a list of the distinct years, which shall be displayed on the y-axis.
You can see, how the source data look like, here:


Can you tell me, how the appropriate DAX formula should look like in the column 'year of reinvestments' to receive the year for each row, where a number is contained?

I would be very grateful about some help.

Kind regards.

[Anonymous · Accepted solution]

Hi

  You can get the result in power query editor itself. 

 Select the year columns and use "Unpivot Columns" transformation.

  Then rename the columns as you like. 

[wech747]

Hi rhariharaneee,

thanks for your quick answer. It works great! 🙂

Kind regards