Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |