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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

Grimfandango227 In Power Query that should be:

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

in DAX

IF([Daily State] <> "Future" || [Daily State] <> "Late", [Daily State] & " " & [Day Name], BLANK() )

Grimfandango227's avatar
Grimfandango227
Frequent Visitor
2 years ago

Good Afternoon Greg_Deckler ,

 

Thanks for the response! Although it does not appear to be working. (See screenshots below)

 

 = DAX

 

Outcome ↓↓

 

 

It would appear that I am still getting the day name with "Future" and "Late" States. 

 

Thanks again for the help!

 

Jeremy