Forum Discussion
index and Match Function in Power BI
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
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 it could be
=averagex(filter(table,table[system name]=earlier(table[system name])),table[day between next brk])
4 Replies
- wdx223_Daniel
Community Champion
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])
Great .. Appreciate your support
Can you suggest syntax in DAX for below Excel formula
- wdx223_Daniel
PradeepVarma it could be
=averagex(filter(table,table[system name]=earlier(table[system name])),table[day between next brk])
