Forum Discussion

Psycho's avatar
Psycho
Frequent Visitor
9 years ago
Solved

Creating a column in a new table with measure values

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...
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    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

     

Bokazoit's avatar
Bokazoit
Icon for Continued Contributor rankContinued Contributor
9 years ago

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's avatar
Psycho
Frequent Visitor
9 years ago

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 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's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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