New Column With Measure

[plunkett40]

I want create a new column measure with the following.  If Task Type is "Coax Splicing" and Task Status is "Complete" then put the Task Status Timestamp data in this column which will be Completion Date.

 

[DataNinja777 · Accepted solution]

Hi @plunkett40 ,

Here’s the DAX formula to create a calculated column:

Completion Date = 
IF(
    'YourTable'[Task Type] = "Coax Splicing" && 'YourTable'[Task Status] = "Completed",
    'YourTable'[Task Status Timestamp],
    BLANK()
)

This formula evaluates each row in the table. If the Task Type is "Coax Splicing" and the Task Status is "Completed", it returns the corresponding Task Status Timestamp as the Completion Date. Otherwise, it returns a blank value.

Since this is a calculated column, it will be precomputed and stored in the dataset, making it useful for table visuals, filtering, and sorting. Let me know if you need any refinements.

Best regards,

[plunkett40]

Fixed a couple of things but not pulling in Task Status Timestamp into new column Buford Completion Date just shows BLANK.  

 

[plunkett40]

Did I do something wrong?  Thanks 

Buford Completion Date 1 = VAR TaskComplete = SELECTEDVALUE('PowerBI_NE_SE_Task_Detail Repor'[Task Status])="Complete" & SELECTEDVALUE('PowerBI_NE_SE_Task_Detail Repor'[Task Type])="Coax Splicing" RETURN IF(TaskComplete, SELECTEDVALUE('PowerBI_NE_SE_Task_Detail Repor'[Task Status Timestamp]), BLANK())