Forum Discussion

Grimfandango227's avatar
Grimfandango227
Frequent Visitor
2 years ago
Solved

Combining two columns with conditions

Hello,    I am trying to combine two columns where it will give me the Day of year # and the day of week name.  The issue is I have some pre-calculations that determine the state of the row to b...
Need Help
mahenkj2's avatar
mahenkj2
Icon for Solution Sage rankSolution Sage
2 years ago

HI Grimfandango227 ,

 

In Power query try as below:

if [Daily State]="Future" or [Daily State]="Late" then "" else [Daily State]&[Day Name]

 

Hope it helps.

Grimfandango227's avatar
Grimfandango227
Frequent Visitor
2 years ago

Hello mahenkj2 ,

 

Thanks for the help, this worked! Although I am wondering, is there a way to still return "Future" and "Late" into that new column just without the number?

 

See screenshot below, 

 

 

Thanks!

 

Jeremy

 

  • mahenkj2's avatar
    mahenkj2
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hi Grimfandango227 ,

     

    Perhaps you could test:

    NewCombine = IF([Daily State] = "Future" , "Future", IF([Daily State] = "Late", "Late", [Daily State] & " " & [Day Name]))

    Hope it helps.