Forum Discussion
Total Projects for Fiscal
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.
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.
