Forum Discussion

NewData's avatar
NewData
Frequent Visitor
4 years ago
Solved

Return first value in given hour range over multiple dates

Hello, I am trying to only return a "1" when a particular model reaches certain set of ranges. Currently, my data keeps returning duplicates. Returns 1 each time that unit is in that range.  Exa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi NewData ,

Please refer to my pbix file to see if it helps you.

Create a measure.

meausre(first value not in range) =
IF (
    (
        MAX ( 'Table'[value] ) >= 10
            && MAX ( 'Table'[value] ) < 15
    )
        || (
            MAX ( 'Table'[value] ) >= 20
                && MAX ( 'Table'[value] ) < 25
        ),
    1,
    0
)

 Best Regards
Community Support Team _ Polly

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

 

 

NewData's avatar
NewData
Frequent Visitor
4 years ago

Anonymous ,

 When applying to entire dataset, it would return a 1 on same Model for each date it's in the range. I would like it to only show a "1" when it's the first instance in the range.