Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm trying to concatenate date and time from different columns in one column in power bi Desktop but i don't known how to do that.
In excel is very simple only i need sum the two columns, por example a1 + b1 where a1 is the date and b1 is the time
Thanks by the help
Solved! Go to Solution.
Hi @Anonymous ,
Try this one for a calculated column:
Hi @Anonymous ,
you can try this:
It works if you have a source table like this:
Hope it helps.
Cheers,
Marco
Hi @Anonymous ,
you can try this:
It works if you have a source table like this:
Hope it helps.
Cheers,
Marco
Hi Marco,
It really did help.
Thanks
Hi @Anonymous ,
Try this one for a calculated column:
Hi
I am very new to PowerBi and I just tried your forumla, it works but I had to make a slight adjustment.
In your answer you are using " ; " between the time periods, PowerBi didn;t like that when I tried it but it worked when I used " , " instead. Not sure if theis is change in PowerBi or typo in your response.
Kinds regards
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |