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
    2 years ago

    Hi Grimfandango227 

    or in DAX

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

     

    Convert both column in text before going for DAX.

     

    Hope it helps.

  • mahenkj2's avatar
    mahenkj2
    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.

fieldsl's avatar
fieldsl
Frequent Visitor
2 years ago

In your Logic Test change the 'Or' to an 'And' 

Option 1
State Combo = IF([Daily State] <> "Future" && [Daily State] <> "Late", [Daily State] & " " & [Day Name], "")

Option 2
State Combo = IF(AND([Daily State] <> "Future", [Daily State] <> "Late"), [Daily State] & " " & [Day Name], "")