Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
joshua1990
Post Prodigy
Post Prodigy

CALCULATED COLUMN Check if order records contains value

Hi all!

I have a table that contains for each order mutliple rows:

OrderValueCheck
100ATRUE
100BTRUE
100CTRUE
101AFALSE

 

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?

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@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 🙂

View solution in original post

1 REPLY 1
SpartaBI
Community Champion
Community Champion

@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 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors