I have a table that contains for each order mutliple rows:
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?
Go to Solution.
@joshua1990 If I understood what you want so something like this:
VAR _current_order = Table[Order]
VAR _list =
Table[Order] = _current_order
VAR _check =
CONTAINS(_list, Table[Value], "C")
In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.