New Table with a summarize column with advanced calculation

Question

Hi, i am a new column generated by the group by of a value open by index, but&nbsp; 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.&nbsp;i leave an example here.&nbsp;&nbsp;&nbsp;limit4250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IndiceValuesCalculation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1164266=4250 +16&nbsp; for the first data, need to do the calculation between the limit and the first value&nbsp;&nbsp;= 42662-234,524015=but, since the second day the sum must be&nbsp; 4266 + ( - 234,52 ) , but if this sum is greater than the limit 4250 the sum mus be 4250 + (-234,52)= 401530,23454016=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)= 4016472,663394088=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5-1,24087=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;623,0065474110=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7-234,523876=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;80,23453876=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1072,663393949=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Answer

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 · Answer

Hi&nbsp;amitchandak&nbsp;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.&nbsp;&nbsp;https://1drv.ms/u/s!AtEkAF7ffIsqg8QydUJ-4mO8DSetEQ?e=haphe9&nbsp;https://1drv.ms/x/s!AtEkAF7ffIsqg8QxJ_vUuiBgTL98uQ?e=Y3uIyZ

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Have your problem be solved?&nbsp;Best Regards,JayCommunity Support Team _ Jay WangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

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

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;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.&nbsp;Best Regards,Jay

Forum Discussion

New Table with a summarize column with advanced calculation

5 Replies

Related content

Parameter in summarize

Don't Summarize....still summarizes...?

calculate with summarize vs values

Advanced filters

GroupBY and summarize

	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	=