Forum Discussion

majinvegito123's avatar
majinvegito123
New Member
3 years ago

Formatting Text Time

Hi everyone. I'm trying to convert a text column that houses TIME information and convert it to show hour, but all the functions I use don't seem to be working. I tried making a measure and columns, but nothing is working for me.

 

StatusTime

112730
113803
113909
114011
114724
125018

 

Example: I want 125018 to show 12:00, 114724 would show 11:00. Can anyone help me with this?

Need Help

2 Replies

  • Bifinity_75's avatar
    Bifinity_75
    Solution Sage
    3 years ago

    Hi majinvegito123, ¿Do you have tried something like this?:

    - Text Column:

    - In Power Query,  in your text column, transform to Hours Format:

    - The result is:

    Best regards

     

     

  • majinvegito123's avatar
    majinvegito123
    New Member
    3 years ago

    It says "

    This query contains transformations that can't be used for DirectQuery.