Forum Discussion
Calculate hours between two date/time column
Hi I have a two calculated column Col1 Col2 27-12-2019 04:35:00 28-12-2019 05:24:00 Need to calculate hours between col2-col1 Both column have date/time datatype I need a total hours bet...
Yep, works
Hi Greg_Deckler edhans Ashish_Mathur
Sorry for my mistake. I made some mistake in calculated column.(I used both date as (start date time) for finding difference).
i think its working fine. Thank you so much for all your replay
Please mark the one that finally nailed it sathyaramesh as the solution so the thread will be solved and others can see the answer easily
- No, my apologies sathyaramesh, that one is all on me, I actually originally posted ,HOURS and moved on and it bugged me whether the syntax was actually HOUR or HOURS but I didn't check, I figured DAX intellitext would save you if I got it wrong. My bad.
