Forum Discussion
Direct Query - Dax Functions
Hi All, I am running a reconciliation exercise between two databases in Power BI. I have chosen direct query mode due to the large volume of data. Below is a simplified model for demonstration, w...
Hi H_insight ,
Can you share some sample data?
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards,
Jay
Hi Anonymous ,
It's a challenge to share a sample file when my question is about DIrectQuery? The connection is direct to the SQL server and not an import model. Hence why I shared a screen of the current model.
For now, I have built a custom SQL code to get me the join between the two tables. Shame it can't be done via DAX "Yet"! Thanks for the follow up 👍
Best Regards,
Hesham