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.
I have written the following Access SQL Query:
SELECT Field1, Field2 * IIf(Field3>Field4,2,3) AS Field5 FROM Table1 WHERE Field6=1 UNION ALL SELECT Field7, Field8 FROM Table2
which I would like to rewrite in Power BI DAX language. How to get started?
Solved! Go to Solution.
Hi @ruut,
Create a calculated table by clicking the "New table" button under "Modeling" tab, please refer to below DAX:
Union Table = UNION ( SELECTCOLUMNS ( FILTER ( Table1, Table1[Field6] = 1 ), "Field1", Table1[Field1], "Field5", Table1[Field2] * ( IF ( Table1[Field3] > Table1[Field4], 2, 3 ) ) ), SELECTCOLUMNS ( Table2, "Field7", Table2[Field7], "Field8", Table2[Field8] ) )
Best regards,
Yuliana Gu
Hi @ruut,
Create a calculated table by clicking the "New table" button under "Modeling" tab, please refer to below DAX:
Union Table = UNION ( SELECTCOLUMNS ( FILTER ( Table1, Table1[Field6] = 1 ), "Field1", Table1[Field1], "Field5", Table1[Field2] * ( IF ( Table1[Field3] > Table1[Field4], 2, 3 ) ) ), SELECTCOLUMNS ( Table2, "Field7", Table2[Field7], "Field8", Table2[Field8] ) )
Best regards,
Yuliana Gu
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |