Forum Discussion
Convert SQL Query to DAX
Sounds like you can do this entirely in the UI, via the matrix visual.
1:1 relationships are usually an indication that tables can be combined into one.
Hi @lbendlinm, I don't know how to do that you are suggesting..matrix visual? I don't have yet the 1:1 relationship, that's I'm pretending converting the Sql query to a Dax and put the result into a Calculated table.
For now, only I have is this table:
This is not a 1:1 reationship, because I have 2 or more records by each Contact ID, I need only one record by each contact ID. Could I do that just using matrix visual? Could you please explain me further how to do that? I'm not super expert on Power Bi, so I'm trying to solve it, but any possible solution so far.
Further details about your solution with Matrix visual based in my screeshot examples above would be greatly appreciated.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523