Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
asdf1608
Helper V
Helper V

Need to convert the tableau query to DAX

I need to convert this tableau calculated field to Power BI query. Help with this is needed.

if isnull[Actual date]

then [planned date]

else [Actual date]

 

How do I convert this to PBI measure?

1 ACCEPTED SOLUTION
jaweher899
Impactful Individual
Impactful Individual

please try 

Measure =
VAR ActualDate = [Actual Date]
VAR PlannedDate = [Planned Date]
RETURN
IF(ISBLANK(ActualDate), PlannedDate, ActualDate)

View solution in original post

1 REPLY 1
jaweher899
Impactful Individual
Impactful Individual

please try 

Measure =
VAR ActualDate = [Actual Date]
VAR PlannedDate = [Planned Date]
RETURN
IF(ISBLANK(ActualDate), PlannedDate, ActualDate)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.