Combining all rows of text in with the same date AND shift

[JWPowder]

Hello, I have a shift report that has mulltiple products names for the same date and shift. My goal is to combine all of the product names for a given shift each day so I can display it as a "current products" dynamic text box on my daily report. Would also need the expression to not include text where "Down" or "0" are the only cell content

Sample Data: 

Desired Result (using 1/13/2023, shift 3 as example) : 

Current Products: GEORGIAN GRAY WRINKLE, 195-E-BROWN,POST OFICE BLUE II, CNH CE GRAY II, FCA GRAY PRIMER 3rd FPO, FCA, SILVER VEIN

Thanks in advance!

[mlsx4 · Accepted solution]

Hi @JWPowder 

Take a look at this post: https://community.fabric.microsoft.com/t5/Desktop/How-to-concatenate-a-list-of-products-by-customer-...

[JWPowder]

@mlsx4 , That was a very helpful post. I grabbed the example and modified with the parameters I listed above. Thank you!

Product List = 
CONCATENATEX (
    CALCULATETABLE ( VALUES ( ProductionLog[Product Name] ),
        FILTER ( ALL ( ProductionLog ),
            ProductionLog[Date_] = EARLIER(ProductionLog[Date_])
                && ProductionLog[Shift] = EARLIER(ProductionLog[Shift])
                && ProductionLog[Product Name]<>"DOWN"
                && ProductionLog[Product Name]<>"FULL SOLVENT IN PROCESS"
                && ProductionLog[Product Name]<>"0"
                && ProductionLog[Product Name]<>"FULL CLEAN NEEDED"
                && ProductionLog[Product Name]<>"DOWN FOR MAINTENANCE"
                && ProductionLog[Product Name]<>"NEEDS CLEAN INTO"
                && ProductionLog[Product Name]<>"CLEAN NEEDED")),
    [Product Name],
    " , "
)

Result:

Text box with a dynamic value of first product list where date equals today.