New Table with a summarize column with advanced calculation

[Anonymous]

Hi, i am a new column generated by the group by of a value open by index, but  i need a new column, which do a new calculation based in a last day calculation, but else need a comparison within a value inside the calculation.

i leave an example here. 

	limit	4250
Indice	Values	Calculation
1	16	4266	=	4250 +16  for the first data, need to do the calculation between the limit and the first value			= 4266
2	-234,52	4015	=	but, since the second day the sum must be  4266 + ( - 234,52 ) , but if this sum is greater than the limit 4250 the sum mus be 4250 + (-234,52)	= 4015
3	0,2345	4016	=	but since the second day the sum is 4015 + ( 0,2345 ) , but if this sum is greater than the limite 4250 the sum must be 4250 + (-234,52)	= 4016
4	72,66339	4088	=
5	-1,2	4087	=
6	23,006547	4110	=
7	-234,52	3876	=
8	0,2345	3876	=
10	72,66339	3949	=

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.

My Recent Blog -
Time Intelligence - Direct Query

[Anonymous]

Hi @amitchandak thank you very much for ur help an attention, here the links with a power bi field and the excel field with some solution for the excersice. 

https://1drv.ms/u/s!AtEkAF7ffIsqg8QydUJ-4mO8DSetEQ?e=haphe9

https://1drv.ms/x/s!AtEkAF7ffIsqg8QxJ_vUuiBgTL98uQ?e=Y3uIyZ

[Anonymous]

Hi @Anonymous ,

Have your problem be solved?

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

hi @Anonymous  am stil without resolution, am trying to do out of power bi, by the way is not my expectative. Can you help me ? thanks! 

[Anonymous]

Hi @Anonymous ,

So you want to calculate a value based on previous value? I'm afraid you can't do it with DAX in my opinion. I think excel can do that.

Best Regards,

Jay