Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

DAX query only working with an additional square closing bracket

Hi, I am using a simple DAX query to calculate 80 percentile from my dataset of 2G voice traffc. But the query only works with an additional closing square paranthesis. Anyone facing a similar issue here?

 

This is the one that works

 

80perc =
PERCENTILE.EXC ( '2GTraffic'[2G Voice Traffic [Erl]]], 0.80 )

 

And this one throws an error, while this is the one that should work

 

80perc =
PERCENTILE.EXC ( '2GTraffic'[2G Voice Traffic [Erl]], 0.80 )

Need Help

2 Replies

  • siddharth1k's avatar
    siddharth1k
    New Member
    1 year ago

    In your example
    '2GTraffic'[2G Voice Traffic [Erl]]
    The column name appears to have an internal square bracket ([Erl]), which is likely causing confusion. Square brackets are used for defining the column name, and having an extra set inside the column name is causing an issue.

  • SamWiseOwl's avatar
    SamWiseOwl
    Icon for Super User rankSuper User
    1 year ago

    Hi Anonymous 

    Could you take a screenshot of your column name in the data pane please