Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Converting Excel Formula to Power BI

Hi All, Need your outmost assistance on converting this excel formula to Dax  Power Bi.  Thank you in advance!!    
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    maybe you can try to create a column

    Column = minx(FILTER('Table','Table'[Validator]=EARLIER('Table'[Validator])&&'Table'[Date of Call]>EARLIER('Table'[Date of Call])),'Table'[Date of Call])

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

maybe you can try to create a column

Column = minx(FILTER('Table','Table'[Validator]=EARLIER('Table'[Validator])&&'Table'[Date of Call]>EARLIER('Table'[Date of Call])),'Table'[Date of Call])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you so much Super  Big Help...