Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I need to create a new table in power BI to write down the follwing (sql)condition:
WITH CTE_1 AS (
--Yes/No Logic applied
SELECT *
FROM [IDW_mart_DEV].[dbo].[v_q]
WHERE
([Question Code] = 'CFOFRQ0036'
OR [Question Code] ='CFOFRQ0037')
AND [Answer Boolean Value] IN ('Yes' , 'No')
)
What I have done so far is:
How do I implement the ( OR) AND
condition.
I tried it, but dod not work.
Any ideas are much appreaciated.
Solved! Go to Solution.
Hi,
Use in {} in your Code :
wonderful, thank you for the learning opportunity!
Hi,
Use in {} in your Code :
User | Count |
---|---|
96 | |
90 | |
72 | |
64 | |
58 |
User | Count |
---|---|
148 | |
112 | |
95 | |
81 | |
71 |