Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.