How to add a column number with max of previous rows in current column

[touseef2660]

I want to write a this formula in calculated column dax in power bi : A5+MAX($B$1:B4)

[touseef2660]

For the  formula you gave Measure 2 = CALCULATE( SUM('Table (4)'[Column1]), 'Table (4)'[Index]<=MAX('Table (4)'[Index]) )  

[touseef2660]

Here commulative gross1 is also a calculated column. which is : if (capital structure[standard filed]="Yes",0,'capital structure'[value])

I think that why the circular dependency error is coming

[touseef2660]

Can I attach a power BI file here? 

[Dangar332]

hi, @touseef2660 

if you have no problem then attach here

[touseef2660]

I cant see the option to attach the power bi file

[Dangar332]

Hi, @touseef2660 

save your file on dropbox or drive or somewhere else

and provide link of file using link icon (see below image)

[touseef2660]

https://1drv.ms/f/c/0509e0cead042ba1/EhtU1pL9m5dDrIYQ30JQUdQB1MtMPTc8qQa9LQ2CyE3dww?e=TXE0jj 

You can find the files here. I tried your formula 

CALCULATE( SUM('Power Bi sheet'[Gross]), 'Power Bi sheet'[Index]<=MAX('Power Bi sheet'[Index]) )
But this is not giving the desired output

[Dangar332 · Accepted solution]

hi, @touseef2660 

it's a measure not a calculated column

if you want to make column try below

Column = 
var a = 'Power Bi sheet'[Index]
return
SUMX(
    FILTER('Power Bi sheet','Power Bi sheet'[Index]<=a),
    'Power Bi sheet'[Gross]
    )

[touseef2660]

Hello, 
With this Dax, it is giving wrong output if negative and zero value is there. For eg:

The output should be:

But it is giving:

[Dangar332]

hi, @touseef2660 

download PBIX file click HERE 
in there mention output with measure and  with column

[touseef2660]

Bro you are amazing. Thanks a ton!!.

[touseef2660]

It is giving the same numbers 

Where as the output should be as below:

@lbendlin 

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[touseef2660]

You can find the files here : https://1drv.ms/f/c/0509e0cead042ba1/EhtU1pL9m5dDrIYQ30JQUdQB1MtMPTc8qQa9LQ2CyE3dww?e=TXE0jj

There are 2 files one is excel and other is power bi. In excel the 2nd sheet has the desired output. In first sheet it is the data which I have uploaded on power bi sample file. 

Thanks

[Dangar332]

Hi, @touseef2660 

put your image erroe image here
or provide some  sample data