Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Expert,
can you help me with my dex formula. I want to count number of days between 2 dates (open date & closed date). But in some scenario closed date is blank.
Regards
Try this if you want to display blanks for no close dates.
no of days=IF(ISBLANK(closed date),BLANK(),DATEDIFF(open date,close date,DAY))
User | Count |
---|---|
128 | |
108 | |
99 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |