Connecting two tables for line graph

[Jason2500]

Hi

I am having sales and expense table as below

Date	Sales
1.02.2021	15
02.02.2021	43
03.02.2021	45
04.02.2021	56
01.03.2021	43
02.03.2021	21
15.03.2021	12

Date	Return
1.03.2021	15
2.03.2021	43
03.03.2021	45
04.03.2021	56
04.03.2021	43
05.03.2021	21
15.03.2021	12

I need to create a single line graph to show the sales and returns. I created a date column using the calendar function and connected both the sales and returns table. Is this the right way to do this? I can get the line graph but not sure whether it's right or wrong?

What would be the best way to create my data model in order to generate a line graph? Please advise

[toafk · Accepted solution]

If I get you right.
Table1 have to columns - Date and Sales

Table2 ahve to columns - Date and Return

In the model tab of Power Bi connect the two table by connecting the dates

Drag the visual on the the report page. Select the Sales and return as values and date as Axis