Forum Discussion
Solved
Power BI Project Management
how do I write dax formula to show all projects where End date is past due and “Project Status” doesn’t show “Complete” or “Cancelled”
&& works but the message i have is "DAX comparison operations do not support comparing values of type Text with values of type Date. Consider using the VALUE or FORMAT function to convert one of the values."
I am unable to use the new column for any visualization.
Best,
Yeboah
Ykankam , Try a measure like
Countrows(filter( Table, Not(isblank(Table[end date])) && [End Date] <= today() && not Table[Project Status] in {"Complete","Cancelled"}))
Do I format this a text? Because when I select this measure, it is unable to display on any visual