How to calculate values based on month and year in bar chart

[Anonymous]

I have a bar chart with Months as x-axis from date table, the sales values are calculated properly on bar chart as sales table has relation with date table. There is another column in sales table called required date. Now I need to calculate the value of sales based on required date and put on same bar chart. Here, the measure should match the month and year from bar chart with required date and give me sales value for items required in specific month and year.

The sales column is called SalesValue and Required Date column is called RequiredDate.

[v-shex-msft]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng