Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all!
I have a table that contains for each order mutliple rows:
Order | Value | Check |
100 | A | TRUE |
100 | B | TRUE |
100 | C | TRUE |
101 | A | FALSE |
Now I would like to add a calculated column (Check), that shows me per Order Number (TRUE /FALSE) if the Order contains a "C" record.
How would you do that as a calculated column?
Solved! Go to Solution.
@joshua1990
If I understood what you want so something like this:
Column =
VAR _current_order = Table[Order]
VAR _list =
CALCULATETABLE(
VALUES(Table[Value]),
REMOVEFILTERS(Table),
Table[Order] = _current_order
)
VAR _check =
CONTAINS(_list, Table[Value], "C")
RETURN
_check
In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂
@joshua1990
If I understood what you want so something like this:
Column =
VAR _current_order = Table[Order]
VAR _list =
CALCULATETABLE(
VALUES(Table[Value]),
REMOVEFILTERS(Table),
Table[Order] = _current_order
)
VAR _check =
CONTAINS(_list, Table[Value], "C")
RETURN
_check
In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |