Get value from a previous row if the next row is Blank

[vishakhawali]

Hi,

I have a Matrix, where my KeyDateLookup is a customised Dimension and my ActualsQoQ, ActualsQoQ_minus1 are my measures which calculate the Cumulative sums.

In the below image for row no 17, I would need the value $1812077.0, 
for row no 114, I would need $6105780.8 and so on for the blank rows and similar calculation would be needed for other measures.

Can you please help me with this?

Thanks

Vishakha

[V-lianl-msft · Accepted solution]

Please try measure like below:

Measure 2 = var current_ = SELECTEDVALUE('Table'[Key Date Lookup])
return IF(ISBLANK([Measure]),CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Key Date Lookup]=current_-1)),[Measure])

I created a sample pbix for your reference

[MFelix]

Hi @vishakhawali ,

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.