Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
In the following image i would like to calculate the variance of ExaminationEndTime and ExaminationStartTime.
the output must be a integer or a whole number in minutes. so for example :
The variance of these two columns on the first row must be 5.
Any suggestions?
Many thanks,
Rega
@Anonymous
You could try
diff mins = IF ( HOUR ( 'Table'[ExaminationEndTime] ) <= HOUR ( 'Table'[ExaminationStartTime] ), DATEDIFF ( 'Table'[ExaminationStartTime], 'Table'[ExaminationEndTime] + 1, MINUTE ), DATEDIFF ( 'Table'[ExaminationEndTime], 'Table'[ExaminationStartTime], MINUTE ) )
Hi @Eric_Zhang,
Thanks for your input but i got the following message:
The start date cannot be greater than the end date...
Hi @Anonymous,
Try to use this calculated column:
Column = ([ExaminationEndTime]-[ExaminationStartTime])*24*60
// in minutes
If not works, try to change the columns to Date/Hour, and check which date you have in both columns.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |