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,
I'm trying to calculate # of days open using a created date column and a closed date column. However the closed date column is sometimes blank(because it is still open).
Here is my formula. I'm getting an error "Too Many arguments were passed to the ISBLANK FUNCTION"
Solved! Go to Solution.
I believe this is just some syntax error, see the revised version below:
# DAYS OPEN = IF ( ISBLANK ( 'List'[CLOSED Date] ), TODAY () - 'List'[Open Date], 'List'[closed Date] - 'List'[Open Date] )
I believe this is just some syntax error, see the revised version below:
# DAYS OPEN = IF ( ISBLANK ( 'List'[CLOSED Date] ), TODAY () - 'List'[Open Date], 'List'[closed Date] - 'List'[Open Date] )
thank you for your help. The corrections you made worked great!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |