Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Min give error due to blank or empty value

Hello, I have follow measure, that works well with most part of values, but it shows error in some cases. if(values(Mastermaterialsap[DChain-spec.])="E51",Measurement[Total months availa...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    3 years ago

    Finally if it has worked. Thanks a lot

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

I think you have an error because the type of data you get with measure is different but this power bi doesn't support.
write like this

= if(
     values(Mastermaterialsap[DChain-spec.])="E51",
            Measurement[Totalmonthsavailable]&"",
                   min(MIN(min(SEM1,SEM2),MIN(SEM3,SEM4)),SEMAF2)&""
)