Power Query excel

[askspepsi]

Greeting all,

I have a small project, in which i have two sql diret query tables and one excel file in that iam trying to show the total of sql and excel for the same designation and for different dates but the total of sum output displaying is correct but its display for all the designation which is wrong. requesting your suggestion for correcting the issue.

Table 1 - direct query	Punching Table - direct query
Id No	Description	EmpId	PunchTime	Projectdetail
1	Fabricator	1	17/09/2020 6:00	Project A
2	Fitter	2	17/09/2020 7:00	Project B
3	Project A	1	17/09/2020 19:00	Project A
4	Project B	2	17/09/2020 19:00	Project B
		1	18/09/2020 6:00	Project A
		2	18/09/2020 7:00	Project B
		1	18/09/2020 19:00	Project A
		2	18/09/2020 19:00	Project B
DAX Date
Excel
Date	Projectdetails	Designation	Total
17/09/2020	Project A	Fabricator	5
17/09/2020	Project B	Fitter	10
18/09/2020	Project A	Fabricator	6
18/09/2020	Project B	Fitter	3
Relationship
Dax date with Excel date
Excel Designation with Table 1 Description
ProjectDeatils Punching Table with Table 1 Description

[Icey · Accepted solution]

Hi @askspepsi ,

Change your relationship like so:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.