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 have a column with a specific ID listed several times and I'm trying to check if any row with a specific ID contains a "Closed" status and if so mark it as "Closed" but if all rows with a specific ID are blank in status, then mark it as "Open" in the newly created column.
Solved! Go to Solution.
Hi @DMB90 ,
You can try below formula to create calculated column:
Status Result =
VAR CurrentID = 'YourTable'[ID]
VAR ClosedCheck =
CALCULATE(
COUNTROWS('YourTable'),
FILTER(
'YourTable',
'YourTable'[ID] = CurrentID &&
'YourTable'[Status] = "Closed"
)
)
RETURN
IF(
ClosedCheck > 0,
"Closed",
"Open"
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DMB90 ,
You can try below formula to create calculated column:
Status Result =
VAR CurrentID = 'YourTable'[ID]
VAR ClosedCheck =
CALCULATE(
COUNTROWS('YourTable'),
FILTER(
'YourTable',
'YourTable'[ID] = CurrentID &&
'YourTable'[Status] = "Closed"
)
)
RETURN
IF(
ClosedCheck > 0,
"Closed",
"Open"
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The column for ID I need is already a measure and won't register. It's called "commentable_id" and is a measure and set to whole numbers.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
70 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
128 | |
29 | |
27 | |
24 | |
22 |