Forum Discussion

Sedos101's avatar
Sedos101
Helper I
3 years ago
Solved

Web2 error

Hi everyone   Trying to copy and paste into this formula into DAX and powerBI keeps crashing, I can't even type it in...   HRI_ = IF ( MAX ( Data[MANAGEMENT_PT] = 0 ), 1, ( IF ( MAX ( Data[...
  • v-luwang-msft's avatar
    3 years ago

    Hi Sedos101 ,

    Your dax statement is too cumbersome, thus causing the error. Referring to below, I copied some of the code in and to the naked eye, it gets more and more jerky as the code grows. Try to optimize your code and try again, you can use SWITCH instead of IF to use.

     

     

    Best Regards

    Lucien