Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Convert 24 HR time

Hi,   I have a column of time data in 24 Hr time:   Time 625 844 1241 1556     Where 625 is 06:25 AM.   How can I convert this into a usable form for PowerBI?   Thank you,    
Anonymous's avatar
Anonymous
Not applicable
10 years ago

I received the following message: Expression error: The name 'CONCATENATE' wasn't recognized. Make sure it's spelled correctly.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

That would be because you were trying to enter a DAX formula into the Query Editor, which uses "M". Import your data and then in the Data tab, go to Modeling in the ribbon and "New Column". I'll see if I can post the equivalent M formula, but please note that you are posting to a forum on DAX Tips and Tricks, not Power Query "M" Tips and Tricks.