Forum Discussion
Solved
Case when in Power BI
I have this SQL code and I need to convert this in a dax in Power BI Can I get some help: Thank you
adoalan you're missing two brackets "))" after "...Street1])" and after "...PostalCode])"
adoalan
You are missing the brackets :-Can you just try this :-
Valldata Fix = IF(nfp_giftaiddeclaration[cratedbyyominame] = "Valldata" && ISBLANK(nfp_giftaiddeclaration[House])
&& ISBLANK(nfp_giftaiddeclaration[Postcode]) && NOT(ISBLANK(RELATED(contact[Address 1: Street 1]))) && NOT(ISBLANK(RELATED(contact[Address 3: ZIP/Postal Code]))), "Y", "N")
I got up to here but still an error
adoalan you're missing two brackets "))" after "...Street1])" and after "...PostalCode])"