Adding month to a year column for a calculation

[Kareem_Amr_IT]

Hello,

I have two sheets, one is sales, and the other is target sales. in the sales is a sales date with all its data, Day, Quarter and so on, but in the target sheet, only the target year is shown as 2020. My dilemma is that I want to create a line column chart showing the sales from the sales sheet vs the Target sales in the target sheet, per month. Of course, since there is no link between them or month in the target, the data is not working, like this: 

And here are the sheets: 

Sales:

 

Target:

My question is, how do I link the two properly or induce a month value from the sales table to the target table if that is applicable?

Thank you

[Anonymous]

Hi @Kareem_Amr_IT ,

I'm a little confused. What's the target for each month if you only have year in target target table, average?

Best Regards,

Jay

[amitchandak]

@Kareem_Amr_IT , I have two blogs and a couple of videos on this topics. But I think this should help

PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...

Others:

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...

https://www.youtube.com/watch?v=yPQ9UV37LOU

https://www.youtube.com/watch?v=6lzYOXI5wfo