I need to Summ sales Qty from a different table for 3 months based on the purcheas month

[Anonymous]

I have one table with Buying data and I want to get the sales Qty based on the buying month.

So there is a table where the rows have Bought Qty (several rows per month on a product) and another table with Sales Qty.

Im trying to find a calculate way where if I bought that product on September, it will add up all the sales qty for September, October, November.

There is one complication... as my Power BI is not recognizing dates.... so I have to do the filters on String level.

This would be a really easy fix in excel with sumifs. but it seems way to complex of a formula in power bi.

So far I tried the following but it comes up empty:

test = Calculate(Sum('Sales Qty for ST'[Sales Qty]);Filter('Sales Qty for ST';'Sales Qty for ST'[Month Name]="September");Filter('Sales Qty for ST';'Sales Qty for ST'[Month Name]="October");Filter('Sales Qty for ST';'Sales Qty for ST'[Month Name]="November"))

If id get this to work... I would add a IF condition for each month. It would look huge... but as I cannot make this first thing to work im back to the start.

Thanks for anyone with some insight.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490