Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |