Assistance Needed - DAX Measure

Hi Yaru_828 ,

You can create measures for "Start Date" & "End Date" & "Age of Project" & "Update On" visualizations.

For example,

end date = IF(ISFILTERED('Table'[Project])||ISFILTERED('Table'[Project Code]),"N/A",FORMAT(MAX('Table'[End Date(Latest SOW)]),"mm/dd/yyyy"))

When you don't select anything from "Project" and "Project Code", it displayed the date.

When you select something from "Project" and "Project Code", it displayed "N/A".

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.