Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to Solution.
Hi @egiam ,
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
Hi @egiam ,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |