Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need your help guys.
It's a simple question and i hope the anwer is simple
I got dates formatted like 3-2-2017 08:00:00 and 3-2-2017 12:13:00 and i need the difference in minutes if that is possible
Solved! Go to Solution.
@RvdHeijden wrote:it states that in DATEDIFF function, the start date cannot be greater than the end date
If you used my formula you should not be getting this error!
See picture...
if start before end +
if end before start -
If both are blank you get zero
if either one is blank you get blank
But no you can mix text and number data types in the same column!
(meaning you can't get numbers when the data is there and then text when its not - but you will get blanks or zero)
Hope this helps!
Good Luck!
Another question because your formula works if both dates have values.
The formula returns an error it seems if one of the 2 dates are empty.
it states that in DATEDIFF function, the start date cannot be greater than the end date
How should i edit the formula so that if one of the 2 dates are empty it returns a value like 'missing data' or something like that ?
@RvdHeijden wrote:it states that in DATEDIFF function, the start date cannot be greater than the end date
If you used my formula you should not be getting this error!
See picture...
if start before end +
if end before start -
If both are blank you get zero
if either one is blank you get blank
But no you can mix text and number data types in the same column!
(meaning you can't get numbers when the data is there and then text when its not - but you will get blanks or zero)
Hope this helps!
Good Luck!
@Sean i copied this formula in another colum and changed the colums for the formula, nothing else but it still reads as an #ERROR.
In DATEDIFF function, the start date cannot be greater than the end date
The new colums only have date values and no tekst
DATEDIFF Hersteltijd =
SWITCH (
TRUE ();
Tickets[Monteur gearriveerd] < Tickets[Technisch gereed]; DATEDIFF ( Tickets[Technisch gereed]; Tickets[Monteur gearriveerd]; MINUTE );
Tickets[Technisch gereed] > Tickets[Monteur gearriveerd]; DATEDIFF ( Tickets[Monteur gearriveerd]; Tickets[Technisch gereed]; MINUTE ) * -1;
0
)
@Sean i found the reason why for formula returns an error and i used the wrong colums in the formula.
I corrected the mistake and now it works flawlessly
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |