Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
109 | |
102 | |
86 | |
77 | |
70 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |