Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
4 years ago
Solved

IF Formula Support

Hi There ;   i need you kind support    i have 4 columns as below , "Order Value " , Invoice Value" , "Order No", Invice No" named   İ want to create a new column as named "Statu" which one mar...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I'd recommend using SWITCH instead of IF.

     

    Statu =
VAR ValO = ISBLANK ( Table1[Order Value] )
VAR ValI = ISBLANK ( Table1[Invoice Value] )
VAR NoO = ISBLANK ( Table1[Order No] )
VAR NoI = ISBLANK ( Table1[Invoice No] )
RETURN
    SWITCH (
        TRUE (),
        NOT ValO && NOT ValI && (   NoO ||     NoI ), "Opened",
        NOT ValO && NOT ValI && NOT NoO && NOT NoI,   "Closed",
        NOT ValO &&     ValI &&     NoO,              "Opened",
        NOT ValO &&     ValI && NOT NoO,              "Closed",
            ValO && NOT ValI &&     NoI,              "Opened",
            ValO && NOT ValI && NOT NoI,              "Closed"
    )

     

     

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

I'd recommend using SWITCH instead of IF.

 

Statu =
VAR ValO = ISBLANK ( Table1[Order Value] )
VAR ValI = ISBLANK ( Table1[Invoice Value] )
VAR NoO = ISBLANK ( Table1[Order No] )
VAR NoI = ISBLANK ( Table1[Invoice No] )
RETURN
    SWITCH (
        TRUE (),
        NOT ValO && NOT ValI && (   NoO ||     NoI ), "Opened",
        NOT ValO && NOT ValI && NOT NoO && NOT NoI,   "Closed",
        NOT ValO &&     ValI &&     NoO,              "Opened",
        NOT ValO &&     ValI && NOT NoO,              "Closed",
            ValO && NOT ValI &&     NoI,              "Opened",
            ValO && NOT ValI && NOT NoI,              "Closed"
    )