Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

syntax Error - Filter = Hitting head

Hi All, 

 

I am trying to write a Measure that converts seconds to hours and then filters by date updated in the last 30 days.

So far I am getting a syntax error on the filter and no matter what I try it just keeps failing.

Any suggestions welcomed:

 

Measure 3 = CALCULATE(SUM('CD'[Column1.fields.timeestimate] ) /3600)
FILTER(((CD[Column1.fields.updated.1]),'CD'[Column1.fields.updated.1] >= TODAY() - 30)
 
 
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Try this:

    Measure 3 =
CALCULATE (
    SUM ( 'CD'[Column1.fields.timeestimate] ) / 3600,
    DATESINPERIOD (
        CD[Column1.fields.updated.1],
        LASTDATE ( CD[Column1.fields.updated.1] ),
        -30,
        DAY
    )
)


    Best Regards
    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    6 years ago

    So your brackets are not matching. You've closed the CALCULATE before the FILTER and there is an extra opening bracket on the FILTER() call that does not have a matching closing bracket.

     

    Also you can't do a filter directly on a column you need to filter a table or a table expression, so you'd need to wrap the reference to CD[Column1.fields.updated.1] at the start of your Filter expression in something like ALL() or VALUES()

     

    So hopefully the following should work:

    Measure 3 = CALCULATE(SUM('CD'[Column1.fields.timeestimate] ) /3600,
    FILTER( ALL(CD[Column1.fields.updated.1]),'CD'[Column1.fields.updated.1] >= TODAY() - 30))

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Try this:

    Measure 3 =
CALCULATE (
    SUM ( 'CD'[Column1.fields.timeestimate] ) / 3600,
    DATESINPERIOD (
        CD[Column1.fields.updated.1],
        LASTDATE ( CD[Column1.fields.updated.1] ),
        -30,
        DAY
    )
)


    Best Regards
    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.