Concatenation or Combinevalues with Conditional

[Stuznet]

Hi guys,
I have 3 columns: Month, Day, Year when I combined them together

Column = [Month] &”/“& [Day] &”/“& [Year]

it gave me the result what I wanted but the new column contains blank with combined value of “/“ .
How do I write a conditional if concantenate is blank do not include “/“ symbol.

Really appreciated if someone can help me out.

[ChrisMendoza · Accepted solution]

@Stuznet,

DAX Solution:

DAX = 
IF (
    Table1[Month] = BLANK() || Table1[Day] = BLANK() || Table1[Year] = BLANK (),
    BLANK (),
    COMBINEVALUES ( "/", Table1[Month], Table1[Day], Table1[Year] )
)

 You could wrap the FALSE statement inside of DATEVALUE to convert the TEXT string into a DATE type as below.

DAX = 
IF (
    Table1[Month] = BLANK() || Table1[Day] = BLANK() || Table1[Year] = BLANK (),
    BLANK (),
    DATEVALUE ( COMBINEVALUES ( "/", Table1[Month], Table1[Day], Table1[Year] ) )
)

[Stuznet]

@ChrisMendoza

Brilliant! Thank you so much for your solution. 🙂