Forum Discussion
Interval calculation
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())
AilleryO It's not clear with the condition whether the result should be 'OK' or 'Not OK'. Can you elaborate on the condition?
Hi,
Thank you for your reply.
I consider line 1 not OK because 8850 (START value on line 1) is between
8746 (START Value on line 2) and 8900 (END value on line 2).
Line 8 is not OK because 8400 (START value on line 8 )is between 8300 (START value on line 7) and 8410 (END value on line 7).
In fact I want to check if the number I find in column START, is included in an interval of any other line.
If the value of the Start column is included in any interval (btwn start and end) of any other line, I want a warning.
Hope it's more clear...
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())
Thanks guy it works like a charm !