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

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.