Forum Discussion

d474boy's avatar
d474boy
Icon for Helper I rankHelper I
7 years ago

How do I create a DateTime field from a Date field and a Number field

Hi everyone, this is my first ever post to the Power BI Community Forums   I am also very new to Power Query and the M Language.   Anyway, I have a query that is pulling out two fields which are ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi d474boy 

Add a custom column

Text.Combine
({
   Text.From(Date.AddDays([Completed Date], Int64.From(
    [Completed Time]/24)), "en-US"), 
   Text.From(Text.Combine
       ({Text.From(Int64.From([Completed Time]), "en-US"),
         Text.From(Int64.From(100*Number.Mod([Completed Time],1)), "en-US")}, ":"),
    "en-US")}, 
":")

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.