Create a new table with 12 calculated measure values in a new column

[Psycho]

Hello!

My Problem:

I have a table with 12 calculated measure values. Now I want this 12 measure show in a line diagram. I want to create a new table with 2 columns (month, calculated measures values). Is it possible to give a cell a direct Link to a measure (like Slink)? Or how can I solve this problem?

Thanks

[v-shex-msft · Accepted solution]

Hi @Psycho,

You can open the query editor and use "Unpivot Columns" function to work through the issue.

Sample:

Use duplicate function to backup this table:

Choose month columns and click on "Unpivot Columns" to merge them:

Result:

After above steps, you can continue the unfinished work.

Regards,

Xiaoxin Sheng

[Psycho · Accepted solution]

Yeah, that is a good solution. But there is my next problem.  🙂

now I have to do completly new calculations. (a lot of them). Do you have a Idea?

I want a calculate like this: 

02 Dur.Bestmge.AktJ = if(Tabelle2[Monat] = "End.Best.Mge.AktJ.02" ; ....

....   (the  value [Bestand] of this row + the value [Bestand] of that row, with the same value of the column [Artikelnummer] and the value "End.Best.Mge.AktJ 01")/2

this is harder than the other problem ^^

Youre idea with:

"SWITCH([Date].[MonthNo],1,[Sum of Jan],2,[Sum of Feb],3,[Sum of Mar],0))"

is very good and it worked. But unfortunately does not react to filter in the first table. Its ever the completly value. Now I must unpivot.  😞