Forum Discussion
Calculation with function in filter
Your static example has the quarter as a text value ("2"). Your roundup function is returning an integeter. You'll need to convert it to a text value with FORMAT() (or change your quarter value to whole number). Also, you can pre-calculate your comparison values as variables first, as follows. This sometimes solves some errors inside calculate.
DPA =
VAR quartervalue =
FORMAT(ROUNDUP ( MONTH ( TODAY () ) / 3, 0 ), "General Number")
VAR thisyear =
YEAR ( TODAY () )
RETURN
CALCULATE (
COUNTROWS ( VALUES ( 'MDS current'[WO #] ) ),
'MDS current'[WO Status] = "COMPLETED",
'MDS current'[RFS Quater] = quartervalue,
'MDS current'[RFS Year] = thisyear
)If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Your static example has the quarter as a text value ("2"). Your roundup function is returning an integeter. You'll need to convert it to a text value with FORMAT() (or change your quarter value to whole number). Also, you can pre-calculate your comparison values as variables first, as follows. This sometimes solves some errors inside calculate.
VAR quartervalue =
FORMAT(ROUNDUP ( MONTH ( TODAY () ) / 3, 0 ), "General Number")
VAR thisyear =
YEAR ( TODAY () )
RETURN
CALCULATE (
COUNTROWS ( VALUES ( 'MDS current'[WO #] ) ),
'MDS current'[WO Status] = "COMPLETED",
'MDS current'[RFS Quater] = quartervalue,
'MDS current'[RFS Year] = thisyear
)
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thx for help, probably working.
I find the problem, my column were not converted to any specyfic type. I change to number and the formula working.
It is quite a strange that i need to do this while there are only numbers.