I am new to Dax. Can someone please help me converting text value to Date/Time?
For example, 071122 (MMDDHH) has to be converted to Date/Time data type. I am not concerned about the format but just want Power Bi to recognize these numbers as date/time.

I’m assuming you did it is a calculated column above. Unless you plan on slicing on that column or using it as the axis on a visual, I would recommend keeping it as a measure with the SELECTEDVALUE in place.

OK - I see the problem - you’ve got Transactions[Hourcalc] coming in as a whole number, rather than text. Because of that, you’re losing the leading zero on single digit months. We need to fix that, either in PQ (preferable) or DAX. If you can please post the underlying data file, I can show you how to write a simple M function to fix this

Okay, this should be bulletproof. Create this as a measure, and it shouldn’t matter whether you have the leading zero or not, or whether you’ve got totals turned on or off in your visual. .

Text to DateTime =
VAR _SelHourCalc = SELECTEDVALUE( Transactions[HourCalc] )
VAR _6Char = IF( LEN(_SelHourCalc) = 6, _SelHourCalc, "0" & _SelHourCalc )
VAR _Year = VALUE(YEAR(TODAY()))
VAR _Month = VALUE(LEFT( _6Char, 2 ))
VAR _Day = VALUE(MID( _6Char, 3, 2 ))
VAR _Hour = VALUE(RIGHT( _6Char, 2 ))
VAR _Date = DATE( _Year, _Month, _Day )
VAR _Time = TIME( _Hour, 0, 0 )
VAR _Result = _Date + _Time
RETURN
IF(HASONEVALUE( Transactions[HourCalc] ), _Result, BLANK() )

The error is gone now but I need to use this measure in graph (Sparkline) which is created using Dax for all the records in table (one graph per record line in table). If I use this formula, the graphs disappears.
The solution that is working for me is this:

VAR _Year = VALUE(YEAR(TODAY()))

VAR _Month = VALUE(LEFT( ( ‘Tablename’[HourCalc] ), 2 ))

VAR _Day = VALUE(MID( ( ‘Tablename’[HourCalc] ), 3, 2 ))

VAR _Hour = VALUE(RIGHT( ( ‘Tablename’[HourCalc] ), 2 ))

Yes, I mentioned above that if you are going to be slicing on this field or using it as the axis in a visual, you will need to use a calculated column (or do it initially in PQ).

The choice is yours, but per calculated column, I would go with the code below since it is protective of the leading zero getting dropped which is what happens when I open your file.

Hi @gkhokher, did the response provided by @BrianJ help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!