Forum Discussion

Yaru_828's avatar
Yaru_828
Frequent Visitor
2 years ago
Solved

Assistance Needed - DAX Measure

Hello Guys, Based on the following data, several visualizations have been created, but how can "Start Date" & "End Date" & "Age of Project" & "Update On" visualizations display N/A when selecting an...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

 

Yaru_828's avatar
Yaru_828
Frequent Visitor
2 years ago

Thanks Stephen, it works