index and Match Function in Power BI

[PradeepVarma]

Hello,

Please refer to below snapshot and syntax of Y3 cell from Excel File, i am looking for equivalent DAX syntax to get similar output in Power BI.

Please review and suggest.

Thanks.,

Pradeep

[wdx223_Daniel · Accepted solution]

in calculated column, this code might work =minx(filter(table,table[system name]=earlier(table[system name])&&table[mulfunction end date]>earlier(table[mulfunction end date])),table[mulfunction end date])

[wdx223_Daniel · Accepted solution]

in calculated column, this code might work =minx(filter(table,table[system name]=earlier(table[system name])&&table[mulfunction end date]>earlier(table[mulfunction end date])),table[mulfunction end date])

[PradeepVarma]

Can you suggest syntax in DAX for below Excel formula

[wdx223_Daniel · Accepted solution]

@PradeepVarma  it could be

=averagex(filter(table,table[system name]=earlier(table[system name])),table[day between next brk])

[PradeepVarma]

Great .. Appreciate your support