Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 :