Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
DAX Solution:
DAX = IF ( Table1[Month] = BLANK() || Table1[Day] = BLANK() || Table1[Year] = BLANK (), BLANK (), COMBINEVALUES ( "/", Table1[Month], Table1[Day], Table1[Year] ) )
DAX = IF ( Table1[Month] = BLANK() || Table1[Day] = BLANK() || Table1[Year] = BLANK (), BLANK (), DATEVALUE ( COMBINEVALUES ( "/", Table1[Month], Table1[Day], Table1[Year] ) ) )
Proud to be a Super User!
DAX Solution:
DAX = IF ( Table1[Month] = BLANK() || Table1[Day] = BLANK() || Table1[Year] = BLANK (), BLANK (), COMBINEVALUES ( "/", Table1[Month], Table1[Day], Table1[Year] ) )
DAX = IF ( Table1[Month] = BLANK() || Table1[Day] = BLANK() || Table1[Year] = BLANK (), BLANK (), DATEVALUE ( COMBINEVALUES ( "/", Table1[Month], Table1[Day], Table1[Year] ) ) )
Proud to be a Super User!