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 the formula. But only when I save the PBIX! So when applying the formula, it works fine, but after saving the file, PBI returns "hey your forumula has 3 extra parenthesis which don't belong there". 

And trust me , there's noting wrong with the formula, it works fine before saving. The error message shows 2 more parenthesis at the end, which PBI keeps adding when saving. And when I delete the last parenthesis in my formula, PBI just adds one more.

 

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

 Result when saving :

IF <same formula>

"#4287f5"  ))) (2 too many)



2 Replies

  • 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"
    )

  • artefarct's avatar
    artefarct
    New Member
    2 years ago

    Hello Bhanu,

    Thank for your quick reply. But I get the same error when saving. Keeps adding extra parenthesis .