Forum Discussion
Domon1996
Feb 13, 2023Copper Contributor
(Q) how to make limited budget in pivot table from power querry
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
- SergeiBaklanDiamond Contributor
Is it possible to share sample file instead of screenshot?
- Domon1996Copper Contributor
Sorry, it just a quick sample that I make for question
Thank youSergeiBaklan
- SergeiBaklanDiamond Contributor
Yes, but that's not a file