Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Mutiple Else IF

I got stuck. How to implement the formula below in Power BI?   if [Current Week]=[Last Week] then "NO1" elseif [Current Week]<[Last Week] then "P1" elseif [Current Week]>[Last Week] then "P2" el...
Show and Tell
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    You are adding a column I suppose: use the code below:

    Column Name= 

SWITCH(
    TRUE(),
 [Current Week]=[Last Week] , "NO1",
 [Current Week]<[Last Week] , "P1",
 [Current Week]>[Last Week] , "P2",
 ISBLANK([Last Week]) , "NE"
)



Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

You are adding a column I suppose: use the code below:

Column Name= 

SWITCH(
    TRUE(),
 [Current Week]=[Last Week] , "NO1",
 [Current Week]<[Last Week] , "P1",
 [Current Week]>[Last Week] , "P2",
 ISBLANK([Last Week]) , "NE"
)