Calculate the first time a value has occurred for this product?

[Zumbug]

Each row is a submission of a product to a system, I am trying to figure out how to make the "Feature A Added" column calculate automatically based on the first three columns.

I want to know at what submission Feature A was added to the product, so in a later report I can display only the rows that had the feature added, without caring about the before and after submissions.

I'm not even sure where to start, any advice is greatly appritiated.

 - Z

[v-yulgu-msft · Accepted solution]

Hi @Zumbug,

Feature A added = 
IF (
    'Feature add'[Submission]
        = CALCULATE (
            FIRSTNONBLANK ( 'Feature add'[Submission], 1 ),
            FILTER (
                ALLEXCEPT ( 'Feature add', 'Feature add'[Product] ),
                'Feature add'[Supports Feature A] = "Yes"
            )
        ),
    "Yes",
    "No"
)

Best regards,

Yuliana Gu

[Zumbug]

This is perfect, thank you very much!

[dramus]

So for a given Product the minimum submission where Supports Feature A is "Yes" ?

[Zumbug]

Yes exactly that!