cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Power Query excel

 

 

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.

 

 

 

Doc1.jpg

 

Table 1 - direct queryPunching Table - direct query
Id NoDescriptionEmpIdPunchTimeProjectdetail
1Fabricator117/09/2020 6:00Project A
2Fitter217/09/2020 7:00Project B
3Project A117/09/2020 19:00Project A
4Project B217/09/2020 19:00Project B
  118/09/2020 6:00Project A
  218/09/2020 7:00Project B
  118/09/2020 19:00Project A
  218/09/2020 19:00Project B
     
DAX Date    
     
     
     
     
Excel  
DateProjectdetailsDesignationTotal 
17/09/2020Project AFabricator5 
17/09/2020Project BFitter10 
18/09/2020Project AFabricator6 
18/09/2020Project BFitter3 
     
     
Relationship   
Dax date with Excel date   
Excel Designation with Table 1 Description  
ProjectDeatils Punching Table with Table 1 Description 

 

 

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi @askspepsi ,

 

Change your relationship like so:

changerelationship.PNGdesignation.PNG

 

 

Best Regards,

Icey

 

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

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @askspepsi ,

 

Change your relationship like so:

changerelationship.PNGdesignation.PNG

 

 

Best Regards,

Icey

 

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

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors