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.
I am trying to create a "baseline" for a list of computers, so if the computer is found in 3 or more columns it should form part of the baseline.
I have tryind with nested "IF" but I do not get the correct returns.
Below is the kind of data I am looking for:
Test BL | AD Devices | ATP Devices | Eracent | SCCM Devices | SNOW Devices |
Yes | Server1 | Server1 | Server1 | Server1 | |
No | Server2 | Server2 | |||
Yes | Server3 | Server3 | Server3 |
Solved! Go to Solution.
@Anonymous write this calculate column:
Column =
VAR _count =
INT('Table'[AD Devices ] <> BLANK()) +
INT('Table'[ATP Devices] <> BLANK()) +
INT('Table'[Eracent]<> BLANK()) +
INT('Table'[SCCM Devices] <> BLANK()) +
INT('Table'[SCCM Devices] <> BLANK())
VAR _result =
IF(_count >= 3, "Yes", "No")
RETURN
_result
@SpartaBI I am looking for a check in "Test BL" to check if the device is in 3 or more columns.
@Anonymous write this calculate column:
Column =
VAR _count =
INT('Table'[AD Devices ] <> BLANK()) +
INT('Table'[ATP Devices] <> BLANK()) +
INT('Table'[Eracent]<> BLANK()) +
INT('Table'[SCCM Devices] <> BLANK()) +
INT('Table'[SCCM Devices] <> BLANK())
VAR _result =
IF(_count >= 3, "Yes", "No")
RETURN
_result
@Anonymous not sure I understand. You can PM me to do a quick zoom if you want.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |