Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Could someone help to find the problem,
I am trying to category data result from diferent columns that has data or not.
lookingto get:
HD_ACT | HD_EXPD | C_ACT | C_EXPD | result | |
HD_ACT | 1 | x | x | x | HD_ACT |
HD_EXPD | x | 1 | x | x | HD_EXPD |
C_ACT | 1 | x | x | x | C_ACT |
C_EXPD | x | 1 | x | x | C_EXPD |
HD_ACT | 1 | 1 | x | x | HD |
HD_EXPD | x | x | 1 | 1 | C |
C_ACT | 1 | x | 1 | x | BOTH_ACT |
C_EXPD | x | 1 | x | 1 | BOTH_EXPD |
But fo some reason the dax is not working.[this is a column calculation]
AAA =
VAR ISData_HD_ACT =
NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_ACT =
ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_HD_EXPD =
NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_EXPD =
ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_ACT =
NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_ACT =
ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_EXPD =
NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_EXPD =
ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
RETURN
IF (
ISData_HD_ACT && ISBlank_HD_EXPD
&& ISBlank_C_ACT
&& ISBlank_C_EXPD,
"HD_ACT",
IF (
ISData_HD_EXPD && ISBlank_HD_ACT
&& ISBlank_C_ACT
&& ISBlank_C_EXPD,
"HD_EXPD",
IF (
ISData_C_ACT && ISBlank_HD_ACT
&& ISBlank_HD_EXPD
&& ISBlank_C_EXPD,
"C_ACT",
IF (
ISData_C_EXPD && ISBlank_HD_ACT
&& ISBlank_HD_EXPD
&& ISBlank_C_ACT,
"C_EXPD",
IF (
ISData_HD_ACT && ISData_HD_EXPD
&& ISBlank_C_ACT
&& ISBlank_C_EXPD,
"HD",
IF (
ISData_C_ACT && ISData_C_EXPD
&& ISBlank_HD_ACT
&& ISBlank_HD_EXPD,
"C",
IF (
ISData_HD_ACT && ISData_C_ACT
&& ISBlank_HD_EXPD
&& ISBlank_C_EXPD,
"Both ACT",
IF (
ISData_HD_EXPD && ISData_C_EXPD
&& ISBlank_HD_ACT
&& ISBlank_C_ACT,
"Both EXPD",
"failure"
)
)
)
)
)
)
)
)
thanks in advance.
Solved! Go to Solution.
I found the error. it has inside of the logic, no symtax issue.
Hi @perezco ,
Glad to hear that you have solved the issue.
And I find that, it is just caused by this:
VAR ISData_C_ACT =
NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) -----------Change to data[C_ACT_SKU_Number]
VAR ISBlank_C_ACT =
ISBLANK ( data[HD_ACT_SKU_Number] ) -----------Change to data[C_ACT_SKU_Number]
VAR ISData_C_EXPD =
NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) -----------Change to data[C_EXPD_SKU_Number]
VAR ISBlank_C_EXPD =
ISBLANK ( data[HD_EXPD_SKU_Number] ) -----------Change to data[C_EXPD_SKU_Number]
Right?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@perezco , can you explain the logic behind the calculation. As if syntax seems fine, You can use switch
Order of condition is important
AAA =
VAR ISData_HD_ACT =
NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_ACT =
ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_HD_EXPD =
NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_EXPD =
ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_ACT =
NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_ACT =
ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_EXPD =
NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_EXPD =
ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
RETURN
Switch ( true() ,
ISData_HD_ACT && ISBlank_HD_EXPD
&& ISBlank_C_ACT
&& ISBlank_C_EXPD,
"HD_ACT",
ISData_HD_EXPD && ISBlank_HD_ACT
&& ISBlank_C_ACT
&& ISBlank_C_EXPD,
"HD_EXPD",
ISData_C_ACT && ISBlank_HD_ACT
&& ISBlank_HD_EXPD
&& ISBlank_C_EXPD,
"C_ACT",
ISData_C_EXPD && ISBlank_HD_ACT
&& ISBlank_HD_EXPD
&& ISBlank_C_ACT,
"C_EXPD",
ISData_HD_ACT && ISData_HD_EXPD
&& ISBlank_C_ACT
&& ISBlank_C_EXPD,
"HD",
ISData_C_ACT && ISData_C_EXPD
&& ISBlank_HD_ACT
&& ISBlank_HD_EXPD,
"C",
ISData_HD_ACT && ISData_C_ACT
&& ISBlank_HD_EXPD
&& ISBlank_C_EXPD,
"Both ACT",
ISData_HD_EXPD && ISData_C_EXPD
&& ISBlank_HD_ACT
&& ISBlank_C_ACT,
"Both EXPD",
"failure"
)
I found the error. it has inside of the logic, no symtax issue.
Hi @perezco ,
Glad to hear that you have solved the issue.
And I find that, it is just caused by this:
VAR ISData_C_ACT =
NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) -----------Change to data[C_ACT_SKU_Number]
VAR ISBlank_C_ACT =
ISBLANK ( data[HD_ACT_SKU_Number] ) -----------Change to data[C_ACT_SKU_Number]
VAR ISData_C_EXPD =
NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) -----------Change to data[C_EXPD_SKU_Number]
VAR ISBlank_C_EXPD =
ISBLANK ( data[HD_EXPD_SKU_Number] ) -----------Change to data[C_EXPD_SKU_Number]
Right?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |