Unpivot of dax data

[Anonymous]

I have a problem regarding unpivot of a dax data table.

The data is as following:

The Black part is kept as is, while the yellow part is what I need to unpivot so it ends with 2 columns:

The title as parameters and the values on the other column.

[Anonymous]

Hi @Anonymous ,

here, i am sharing my screenshots how I converted unpivot columns. 

1. this is my Excel data(see, I have null values means this all are empty cells )

2. after I replace "null" values into "0" 

3. I select all columns by using cntl option (Excepts first two columns)

4. see, we have Transform tab one option is there Unpivot Columns

5. click unpiovt option, after we are getting result like this.

6. change column name

regards,

Naveen

[Anonymous]

I know about the power query method. The reason I did not use it is because I have calculations in the columns. But I have somehow found a youtube that may get me through. thanks anyways.

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

If you want to unpivot the data by dax, you could try this way:

https://community.powerbi.com/t5/Quick-Measures-Gallery/DAX-Unpivot/td-p/574832

Best Regards,

Lin