topic Re: IF AND dax statement assistance in DAX Commands and Tips

IF AND dax statement assistance

adoster — Wed, 16 Feb 2022 20:57:14 GMT

Hi,

Having some difficulty creating a new column using an IF/AND statement

New column should only show values that are Phase 3 AND have been billed

Simple data example

Here is what i've tried

Phase3Billed = IF ('All HOD Visits'[PRC_NAME] = "Phase 3" && 'All HOD Visits'[BILLING PROVIDER NAME] <> BLANK(), "Billed P3", 0)

This returns an error "Expressions that yield variant data-type cannot be used to define calculated columns

Thanks for any assistance!

Whitewater100 — Wed, 16 Feb 2022 21:22:09 GMT

Hello:

You can try

IF(AND('All HOD Visits'[PRC_NAME]= "Phase 3", NOT(ISBLANK('All HOD Visits'[BILLING PROVIDER NAME]), "Billed P3", 0))

I hope this works for your application.

adoster — Wed, 16 Feb 2022 21:31:49 GMT

That returns "Operator or expression '()' is not supported in this context

Whitewater100 — Wed, 16 Feb 2022 21:34:10 GMT

Sorry You just add "0" to your zero at the end. That way it is all string data.

Test = IF(AND('All HOD Visits'[PRC_NAME] = "Phase 3", 'All HOD Visits'[BILLING PROVIDER NAME] <> BLANK())), "Billed P3", "-")

Whitewater100 — Thu, 17 Feb 2022 01:24:58 GMT

IF(AND(('All HOD Visits'[PRC_NAME]= "Phase 3", 'All HOD Visits'[BILLING PROVIDER NAME]) <> BLANK())), "Billed P3", "blank")

This should work.