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.
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.
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 = CALCULATE ( CONCATENATEX ( VALUES ( Vocabulary[Name] ), [Name], "-" ), Vocabulary[VocabularyTypeID] = 20 )
The CONCATENATEX is trying to convert table values to a scale value.
Best Regards!
Dale
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.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |