Showing results for 
Search instead for 
Did you mean: 
vikramd8 Frequent Visitor
Frequent Visitor

Converting SQL Query to a DAX query

Hi All, 


please help me to convert this SQL query to a DAX query. 


select b.Name
from [CPHS_Dev_New].[Health].[Patient] a
full outer join [CPHS_Dev_New].[Common].[Vocabulary] b
on a.SmokingStatusCode=b.Code
where b.VocabularyTypeId=20. 



Community Support Team
Community Support Team

Re: Converting SQL Query to a DAX query

Hi @vikramd8,


Why do you want a DAX query for this SQL statement? You can do it without a code.

1. Import tables Patient and Vocabulary.

2. Establish relationship between Patient[SmokingStatusCode] and Vocabulary[Code].

3. Drag the Vocabulary[Name] to a table visual.

4. Filter Vocabulary[VocabularyTypeId] equal 20 either by a slicer or a filter in the pane.


The Dax could be like this following the step 2 above.

Names =
    CONCATENATEX ( VALUES ( Vocabulary[Name] ), [Name], "-" ),
    Vocabulary[VocabularyTypeID] = 20

The CONCATENATEX is trying to convert table values to a scale value.


Best Regards!


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