I have a question about how to split revenue based on a percentage of total over other cost centers or products. In this case we have three cost centers.
Overall = overhead and works for all the cost centers
Strategy
Studio
I would like to split the hours and/or revenue of the “Overall” cost center over the cost centers, based on the percentage of the total. The table underneath makes it more clear. Someone any suggestions or sollutions?
Thank you a lot for your time. I understand the logic of the dax, but it has to be more dynamic. In this case a project has 2 cost centers, but it can be 5 cost centers aswell. (I didn’t explain that in the first place, sorry!) So for example:
Project 1: Cost Centers: Strategy and Studio
Project 2: Cost Centers: Strategy, Growth en Studio
Project 3: Cost Centers: Studio, Media, Labs.
Project 4: Cost Centers: Strategy, Growth, Studio and Labs.
Hi @Nick1, did the response provided by @Dharma help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.
Hello @Nick1, did the response above help solve your query? It’s been a while since we got a response from you. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @Nick1, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
