Values by month

[Anonymous]

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 

[Anonymous · Accepted solution]

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]

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]

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