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: 
Reply
singleton2787
Helper III
Helper III

Simple question hopefully.. is one date field is blank, use another

‎09-23-2022 10:28 AM
DoneDate =
IF (
    'WorkItems Completed'[Custom_DateDeployed].[Date] = BLANK (),
   'WorkItems Completed'[Custom_TargetDeploymentDate].[Date] )
 
 
This is not working... any ideas?
Labels:
Message 1 of 3
97 Views
0
1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

‎09-23-2022 10:35 AM

Try it like this.

DoneDate =
IF (
    ISBLANK ( 'WorkItems Completed'[Custom_DateDeployed] ),
    'WorkItems Completed'[Custom_TargetDeploymentDate],
    'WorkItems Completed'[Custom_DateDeployed]
)

View solution in original post

Message 2 of 3
89 Views
2 REPLIES 2
singleton2787
Helper III
Helper III

‎09-23-2022 10:39 AM

perfect!! ty!

Message 3 of 3
86 Views
0
jdbuchanan71
Super User
Super User

‎09-23-2022 10:35 AM

Try it like this.

DoneDate =
IF (
    ISBLANK ( 'WorkItems Completed'[Custom_DateDeployed] ),
    'WorkItems Completed'[Custom_TargetDeploymentDate],
    'WorkItems Completed'[Custom_DateDeployed]
)
Message 2 of 3
90 Views

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

View All