Is there a way in Power BI to sum all values in the column that come before an empty row?

[eliele]

Hey,

I am trying to sum all values in column "Delta" (please see below) that come before the first empty row. Is there a way using DAX to do this?  In other words, for the below data, I need a measure that calculates 2.1 + 3.5 + 7.7 + 1.2 = 14.5.

ID	Delta
1	2.1
2	3.5
3	7.7
4	1.2
5
6	5.8
7	1.0
8
9	4.5
10	6.8
11
12	2.1
13
14

Thank you!

[v-yulgu-msft · Accepted solution]

Hi @eliele ,

You can create a measure as below:

Measure 3 =
VAR _minID =
    CALCULATE ( MIN ( Sheet6[ID] ), Sheet6[Delta] = BLANK () )
RETURN
    CALCULATE ( SUM ( Sheet6[Delta] ), Sheet6[ID] < _minID )

Best regards,

Yuliana Gu

[eliele]

Thank you @v-yulgu-msft!!