topic Re: Nested if blank statement in DAX Commands and Tips

Nested if blank statement

Anonymous — Mon, 17 Jul 2023 07:51:45 GMT

COSTCENTER_fix = IF( ISBLANK('sapdata SAP_generalaccounting'[COSTCENTER]), IF( ISBLANK('sapdata SAP_generalaccounting'[WBS_ELEMT]), 'sapdata SAP_generalaccounting'[PROFIT_CTR], LOOKUPVALUE('sapdata SAP_projektelement'[Ansvarigt_kostnstl], 'sapdata SAP_projektelement'[WBS_element], 'sapdata SAP_generalaccounting'[WBS_ELEMT]) ), 'sapdata SAP_generalaccounting'[COSTCENTER] )

Here is my current code that is not working.

I want to check if column COSTCENTER is blank
if it is blank use values from LOOKUPVALUE from WBS_ELEMNT
and if both are blank I want the values from PROFIT_CTR

problem is values from profit_ctr are not being entered, if both are blank this column is also blank. I cannot have blank rows in this column

Re: Nested if blank statement

wdx223_Daniel — Mon, 17 Jul 2023 08:59:52 GMT

may there are some non-true blank values in the column of WBS_ELEMNT

Re: Nested if blank statement

Anonymous — Mon, 17 Jul 2023 09:54:22 GMT

Ah yes you are correct, now that I checked it is just no text instead of (blank). What would be the best way to fix this?

Re: Nested if blank statement

wdx223_Daniel — Mon, 17 Jul 2023 23:18:07 GMT

'sapdata SAP_generalaccounting'[WBS_ELEMT]=""