Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I've a DB which is very detailed (breakdown by Category, Customers and so many others).
I've fixed Costs on Total Category.
If I do a simple merge query, then I will have the same fixed cost on all lines, this is not what I want...
In Excel I would have managed it via a ratio [Turnover of the line / Sumifs(total Turnover, same Category)] * fixed cost. I must precise that I'm in Excel Power Query Only (not power BI) so I can't do it via DAX.
Is there any way to :
Thank you in advance for your help.
Laurent
Solved! Go to Solution.
Hello @LaurentZ
to use Table.Group and Table.Join/NestedJoin is just fine and for sure the reccomended approach to take.
What should be wrong about that?
Jimmy
Hello @LaurentZ
to use Table.Group and Table.Join/NestedJoin is just fine and for sure the reccomended approach to take.
What should be wrong about that?
Jimmy
Hi @Jimmy801,
First, thank you for your answer.
Well that's not a wrong way to do it, I was just wondering if there is another way to do it.
Ok, then I go with a groupby and merge.
Regards,
Laurent