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])

Msaba's avatar
Msaba
Frequent Visitor
4 years ago

Hi All,

Need same assistance in converting this excel formula to Dax  Power Bi. 

=IF(ISNUMBER(SEARCH("REL CNF",[@[System status]])),"CNF",MID([@[System status]], 1, 4))

 

Thank you a lot!