Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with Returning Earliest Date based on certain criteria

Hi All, hoping someone might be able to help as I have tried a few different ways to do this but fail each time to get what I need.   So I have one table with a list of Products, and the number of ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Cherry, that worked beautifully, thank you so much, and thank you for quick response. This forum is such a great resource for newbies to powerbi like myself and I am sure more seasoned users. Thanks again really helpful.

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

By my test with your data sample, the measure below could achive your desired output.

Measure =
CALCULATE (
    MIN ( 'Table1'[Date] ),
    FILTER (
        ALLEXCEPT ( Table1, 'Table1'[Week], Table1[Product] ),
        'Table1'[Number] = 2
    )
)

Here is the output.

Best  Regards,

Cherry

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Cherry, that worked beautifully, thank you so much, and thank you for quick response. This forum is such a great resource for newbies to powerbi like myself and I am sure more seasoned users. Thanks again really helpful.