Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Values by month

Hello!

 

I have one table with values per different dates, Table 1 in figure, which do not have any values certain dates and months. I have one table with a percentage for each month under a year (Table 2). I now want to create a visual result table that show according to the result table in figure below. It should sum all values in Table 1 to one total sum, then multiply the total sum from Table 1 by each month’s percentage in Table 2. The result table should ignore selections of month but accept change in year.

 

 

 

Hope you can help. 

 

Best regards

Mårten 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,

     

    Make sure that your month in table 2 is formatted as don't summarize.

     

    Then you can use this measure:

    Result := SUM(Table2[Percentage per]) * SUM(Table1[Values])

     

    This does give me your desired result when i recreated this.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Make sure that your month in table 2 is formatted as don't summarize.

     

    Then you can use this measure:

    Result := SUM(Table2[Percentage per]) * SUM(Table1[Values])

     

    This does give me your desired result when i recreated this.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Maybe I didn’t explain so well but this proposal will not give me values for the month that have not values in date and value coulmns in table 1.   

       

      Thanks!

       

      Best regards 

      Mårten 

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi Anonymous，

         

        By my tests, the formula from Jeltex could give your desired result.

         

         

        However, I'm confused about your logic. Maybe I miss something?



        Maybe I didn’t explain so well but this proposal will not give me values for the month that have not values in date and value coulmns in table 1.   

         

         

        Could you describe it in more details?

         

        Best Regards,

        Cherry