Forum Discussion
Solved
Total Projects for Fiscal
I am trying to create a card that shows the total number of projects for the current fiscal year. I created the following measure but I am getting an error that seems to be related to the RETURN port...
Hi Jhadur ,
It looks like there is an error in your DAX code that is preventing the data from being loaded. The error message states that the text value “BNSPRJOP230245” could not be converted to a True/False type. This is usually because the text value is used in a logical expression.
So I think you can just calculate the value returned by _Table. Here is my modified DAX code:
TOTAL PROJECTS FOR FY = VAR __MinDate = DATE ( 2023, 11, 01 ) VAR __MaxDate = DATE ( 2024, 10, 31 ) VAR __Table = FILTER ( 'Projects', [Start] >= __MinDate && 'Projects'[Start] <= __MaxDate ) RETURN COUNTROWS ( __Table )Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Jhadur ,
regardless of the logic, you're returning a variable that is not defind.
if the last variable that returns the number is __calculate, then you should return __calculate