Forum Discussion
Help with DAX Formula please
I have this piece of SQL code and I need to convert it in a DAX formula. I got half way through it and the below is working perfectly: TESTAGAIN = SWITCH( TRUE(), ISBLANK('nfp_g...
I created coloumn and getting this
Hi adoalan ,
I have replicated the same with a sample table with 3 rows,
Please see you can access the attached one drive link.
I created this table -
and using this calcution -
Column =
IF(
'Table'[Forename]=BLANK() ||
'Table'[Surname]=BLANK() ||
'Table'[House]=BLANK() ||
'Table'[Postcode]=BLANK() ||
CONTAINSSTRING('Table'[Forename],"&") ||
CONTAINSSTRING('Table'[Surname],"&"),"Yes",
"No")
You can use this formula directly you just have to replace the table name.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Did I answer your question? Mark my post as a solution!