Forum Discussion

AilleryO's avatar
AilleryO
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

Interval calculation

Hi,   I am with a problem that should be easy, but I'm stuck... My data are like this : My need is to check if the number in the start column is between the start and end numbers of the oth...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    AilleryO Try this:

    Warning_calc_column=var CurrentIndex='Table'[Index]

    var CurrentStart='Table'[Start]

    var TempTable=FILTER(ALL('Table'),'Table'[Index]<>CurrentIndex&&'Table'[Start]<CurrentStart&&'Table'[End]>CurrentStart)

    return IF(COUNTROWS(TempTable)>=1,"Not OK",BLANK())

Anonymous's avatar
Anonymous
Not applicable
5 years ago

AilleryO It's not clear with the condition whether the result should be 'OK' or 'Not OK'. Can you elaborate on the condition?