Forum Discussion
Sedos101
3 years agoHelper I
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[...
- 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
v-luwang-msft
3 years agoCommunity Support
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