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.
Hi, Since my skills about Power BI are in progress I have a lot of questions, currently I am writting a report that use a lot of business rules and there are some formulas(business rules) that need to be build, for instance: I have a datetime 20180615 10:13:00, do I need to do is to set up the date time to 20180615 07:00:00 and calculate the lapsed time between both datetimes, in this case the lapsed time will be 3:13 hours, well, I am wondering if I can create a Formula and add this formula during the calculation of a column, you can notice that this value will be like a constante, take the daily day and calculate the lapsed time.
Rigoleto
Solved! Go to Solution.
Hi @Rigoleto
Let me show you an example
create a calculated column
column = CONCATENATE ( CONCATENATE ( DATEDIFF ( [set up time], [datetime1], HOUR ), ":" ), MOD ( DATEDIFF ( [set up time], [datetime1], MINUTE ), 60 ) )
Or, you can create a measure
Measure = CONCATENATE ( CONCATENATE ( DATEDIFF ( MAX ( [set up time] ), MAX ( [datetime1] ), HOUR ), ":" ), MOD ( DATEDIFF ( MAX ( [set up time] ), MAX ( [datetime1] ), MINUTE ), 60 ) )
Best Regards
Maggie
Hi @Rigoleto
Let me show you an example
create a calculated column
column = CONCATENATE ( CONCATENATE ( DATEDIFF ( [set up time], [datetime1], HOUR ), ":" ), MOD ( DATEDIFF ( [set up time], [datetime1], MINUTE ), 60 ) )
Or, you can create a measure
Measure = CONCATENATE ( CONCATENATE ( DATEDIFF ( MAX ( [set up time] ), MAX ( [datetime1] ), HOUR ), ":" ), MOD ( DATEDIFF ( MAX ( [set up time] ), MAX ( [datetime1] ), MINUTE ), 60 ) )
Best Regards
Maggie
So, yes you could create a measure that does this calculation and then use this measure in other measures or column calculations.
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |