Summing Values BETWEEN Two Dates AND Count consecutive days In Power BI

Hi  Anonymous ,

Create measure.

mod_measure = MOD(MAX('Table'[rank]),2)

Over_TWO_measure =
var _current=SUMX(FILTER(ALL('Table'),'Table'[Date]=MAX('Table'[Date])),[count])
var _next=
IF(
    MAX('Table'[Date])=MINX(ALL('Table'),'Table'[Date]),_current,
SUMX(FILTER(ALL('Table'),'Table'[Date]=MAX('Table'[Date])-1),[count]))
return
IF(
    _current=_next&&MAX([count])>=2&&[mod_measure]=0,1,0)

Result:

Best Regards,

Liu Yang

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