Need Repeated value in with respect to blank dates

[mohittimpus]

Hello All,

I need Repeated value in with respect to blank dates below i am showing image with red color values.

.pbix file:

https://drive.google.com/file/d/1p-ryWXkF0kx3VkRRPtiRjccOeja8QohZ/view?usp=sharing

[v-easonf-msft · Accepted solution]

Hi, @mohittimpus 

Try measure as below:

Measure2 = 
VAR a =
    SELECTEDVALUE ( 'Date'[Date] )
VAR b =
    CALCULATE (
        MAX ( 'Date'[Date] ),
        FILTER ( ALL ( 'Date' ), 'Date'[Date] <= a && [M] <> BLANK () )
    )
RETURN
    CALCULATE ( [M], 'Date'[Date] = b )

Please check my pbix file for more details.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@mohittimpus , Try a measure like

calculate([lead expected], filter(allselected(Table), Table[Date] = calculate(Max(Table[Date]), filter(allselected(Table), Table[Date] <=max(Table[Date]) && not (isblank([lead expected]))))))