Forum Discussion

Artefact's avatar
Artefact
Icon for Helper II rankHelper II
2 years ago

Extra parenthesis added after saving file

Hi, Sometimes PBI adds a lot of extra parenthesis at the end of a DAX formula. Till now after copy paste the formula they don't show up again. But now PBI keeps adding them and returns an error on t...
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

Artefact , Try using Variables

 

VAR AgeAverage = AVERAGE(workorder_time[Age in years])
VAR TotalSpent = [Total spent time]
RETURN
IF (
OR (
AND (AgeAverage > 29, TotalSpent > 55),
AND (AgeAverage < 30, TotalSpent > 50)
),
"#4287f5"
)