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,
im trying to calculate the number of days an item is opened. (Attached below)
If Column A is Blank, Column B should show the number of days an item is opened for
However if column A has a date, then colmn B should be blank or have "0"
Another issue im having is the huge negative number on column B
Thank you
Solved! Go to Solution.
@Anonymous , Try a new column like
if(isblank([A]), datediff([date creation],today(), day), 0)
@Anonymous , Try a new column like
if(isblank([A]), datediff([date creation],today(), day), 0)
Worked. Thank you
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |