Excel Second minif in Powerbi calculatd column

[emrei]

Hi everyone, I have the following two tables. In the analysis table I get the earliest and second earliest part received date for each part with date information coming from the data table.

For the earliest received date in excel i use: =MINIFS(C:C,B:B,F4)

And for the second earliest received date in excel i use:  =MINIFS(C:C,B:B,F4,C:C,">"&MINIFS(C:C,B:B,F4))

I am trying to replicate this analysis in powerbi for the analysis table as a calculated column. I was able to get the earliest date with the folowing funciton = CALCULATE(min('data table'[received date]),ALLEXCEPT('analysis table'[part])). I am having trouble calculating the second earliest received date since filter won't work for two tables. Does anyone have any ideas?

TLDR: How to convert =MINIFS(C:C,B:B,F4,C:C,">"&MINIFS(C:C,B:B,F4)) excel formula to powerbi calculated column

Thank you!

Best,

Emre

[ryan_mayu · Accepted solution]

@emrei 

you can try this

Column 2 = CALCULATE(min('Table'[Received Date]),FILTER('Table','Table'[part]='Table (2)'[part]&&'Table'[Received Date]>'Table (2)'[Column]))

[emrei]

works perfectly, thanks

[ryan_mayu]

you are welcome