The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
please try
Measure =
VAR ActualDate = [Actual Date]
VAR PlannedDate = [Planned Date]
RETURN
IF(ISBLANK(ActualDate), PlannedDate, ActualDate)
please try
Measure =
VAR ActualDate = [Actual Date]
VAR PlannedDate = [Planned Date]
RETURN
IF(ISBLANK(ActualDate), PlannedDate, ActualDate)