syntax Error - Filter = Hitting head

[Anonymous]

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)

[Icey · Accepted solution]

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.

[d_gosbell]

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