Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Datediff with value for blank

‎10-27-2021 01:18 PM

Hello Everyone, 

What I am trying to do is simple. I have a starting date (Created date) and closed date (Resolved Date).  With this formula I am using on the data table, when there are no dates in Resolved Dates it gives me blank. What I would like power bi to do is lable any row in resolved date column that is blank with the text "open" This way I know the ticket is still open and has not been resolved  

 

Formula:

Resolved Duration = DATEDIFF('FreshService Data RAW'[Created Date],'FreshService Data RAW'[Resolved Date],DAY)
Labels:
Message 1 of 3
1,749 Views
0
1 ACCEPTED SOLUTION
KNP
Super User
Super User

‎10-27-2021 07:23 PM

Hi @Anonymous,

 

See attached PBIX, specifically the calculated column formula.

I hope this helps.

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		xOIEmaj

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
image		fabric-SUbadge
Proud to be a Super User!

View solution in original post

CalculatedColumn_ShowDateDiffOrOpen.pbix
Message 2 of 3
1,671 Views
2 REPLIES 2
Anonymous
Not applicable

‎10-29-2021 08:50 AM

Thank you so much! This worked perfectly 

Message 3 of 3
1,629 Views
0
KNP
Super User
Super User

‎10-27-2021 07:23 PM

Hi @Anonymous,

 

See attached PBIX, specifically the calculated column formula.

I hope this helps.

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		xOIEmaj

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
image		fabric-SUbadge
Proud to be a Super User!
CalculatedColumn_ShowDateDiffOrOpen.pbix
Message 2 of 3
1,672 Views

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Kudoed Authors
View All