Forum Discussion
Helper IVDAX comparison operator with and statements
I am getting a dax comparison error. I have two statements OLI Status needs to be active status needs to equal 20 and fc flag needs to be = "N", the next statement is OLI Status needs to be active status needs to equal 80 and fc flag needs to be = "Y". Not sure what is incorrect.
poweruser55 , Check if _C_SP_status is number or text, Check same for other two columns two , if text put value in double quote
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
1 Reply
- amitchandak
Super User
poweruser55 , Check if _C_SP_status is number or text, Check same for other two columns two , if text put value in double quote
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.