Skip dates with no value and return the closest date with value

[fozjugho]

Hello all,

I want to ask you for a help with my DAX formula.

I have dates (blue text on the left), but some of the dates do not have assigned value (measure "Cil splnen"). I want to skip those dates and return the next date that has a value. The desired output is in red - for third date instead of 16.7. I want to return 14.7.

[amitchandak · Accepted solution]

@fozjugho ,  Try these 2 measures, use second one in visual for <= 3 or =3 

M1 = Countx(Filter(Values(Table[Date]) , Not(Isblank([Cil splnen])) ), [Date])

M2  = Sumx(Filter(  Values(Table[Date]) , [M1] <=3 ), [Cil splnen] )

[fozjugho]

Thank you, it helped