Forum Discussion
converting sql case statement to Dax
Hi,
Does anyone know how I would convert this SQL case statement to DAX? Thanks!
sum(case when ISNULL(A.CON_CODE,'Z') = '' and ISNULL(A.DEC_AM,0) > 0
and A.APP_DEC ='C' and A.BK_DT is not null then 1 else 0 end)
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
Flag = var _first= IF( 'Table'[A.CON_CODE] = BLANK(),"Z",[A.CON_CODE]) var _second= IF( 'Table'[A.DEC_AM] = BLANK(),0,[A.DEC_AM]) return IF( _first="Z"&&_second>0&&'Table'[A.APP_DEC]="C"&&'Table'[A.BK_DT] <> BLANK(),1,0)Dax = SUMX( 'Table',[Flag])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
Flag = var _first= IF( 'Table'[A.CON_CODE] = BLANK(),"Z",[A.CON_CODE]) var _second= IF( 'Table'[A.DEC_AM] = BLANK(),0,[A.DEC_AM]) return IF( _first="Z"&&_second>0&&'Table'[A.APP_DEC]="C"&&'Table'[A.BK_DT] <> BLANK(),1,0)Dax = SUMX( 'Table',[Flag])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly