(Q) how to make limited budget in pivot table from power querry

Copper Contributor


I have a problem that my budget limit is wrong 

(That set of data is an example. The real one is very large and got unpivoted)

That what I think it gonna work but maybe I miss something

1.Can we make a grand total that sum from average of average of limit ?

2.I try =CONCATENATEX(VALUES once in add measure but I need calculation

3.I try to merge 2 table by Name but it told me many to one or one to many not work (my data is larger and have more column that unpivoted)

Thank you

3 Replies


Is it possible to share sample file instead of screenshot?

Sorry, it just a quick sample that I make for question 

Thank you@Sergei Baklan 


Yes, but that's not a file