Creating a column in a new table with measure values

[Psycho]

Hello,

My problem:

I have a table with a lot of calculated measure values. One per month. Now i want this values in a line diagramm.

I want to create an new table with 2 Columns (1x month, 1x measure values). Is it possible to give every cell in the new table a link to a measure value.

[Bokazoit]

I do not think it is all clear what You want, but You can add several measuresinto the Values field of a table, but I think that is what You have already done.

[Psycho]

 I'm looking for a solution to assign my Measures a concrete cell, when I create a new table in Desktop Power BI.

Picture 1: These values ​​it is

Picture 2: This should be the new table. But I do not know the Synthax so PBI takes the values.

Picture 3: Example Values

[v-caliao-msft · Accepted solution]

Hi @Psycho,

In your scenario, you create measure for each month individually, are you using the same formuls for each month?

If that is the case, you needn't to create a measure for each month. It can be done in one measure. From your screenshot, it seems that you use count aggregate function in your Values. I have created it on my local environment, here is the sample measure for you reference.
Measure = CALCULATE(SUM(Sales[SalesAmount]),ALLEXCEPT('Date','Date'[Column]))

If this is not what you want, please provide us more information about your measure, so that we can make further analysis.

Regards,

Charlie Liao