Forum Discussion
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...
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.
Hi Grimfandango227 ,
Perhaps you could test:
NewCombine = IF([Daily State] = "Future" , "Future", IF([Daily State] = "Late", "Late", [Daily State] & " " & [Day Name]))Hope it helps.
mahenkj2
Solution Sage
Solution SageHI Grimfandango227 ,
In Power query try as below:
if [Daily State]="Future" or [Daily State]="Late" then "" else [Daily State]&[Day Name]
Hope it helps.
- mahenkj2
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.
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
Hi Grimfandango227 ,
Perhaps you could test:
NewCombine = IF([Daily State] = "Future" , "Future", IF([Daily State] = "Late", "Late", [Daily State] & " " & [Day Name]))Hope it helps.
