Budget constraints

DAX DAX Calculations
1

Hi
I have a pretty simple problem that I would really appreciate your help with.

I have a table with Project Values and a table with Line Item Estimates.
Each project has 3 line items and each line item makes up a % of the project value.
I am trying to make a third table that shows the line items per project.
I have an example of what i want the third table to show in Line Item Constraints table that is included.
Hope I have explained this well.

thanks
James
Budget Constraint Example.pbix (39.0 KB)

2

Hi James,
I have recreated your model in the attached file.
I have created the third table as follows:

  1. Home/New Table
  2. Line Item Constraints = CROSSJOIN(‘Line Estimates’,‘Project Values’)
  3. Add column: Budget Constraint Budget Constraint = [Total Budget]*[Sum of % Estimate Contract Values]
    Let me know how your go.
    Kim
    Budget Constraint Example v2.pbix (25.6 KB)
3

Hi @jsavage, did the response provided by @KimC help you solve 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.

I hope that you are having a great experience using the Support Forum so far. Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!

4

Hi @jsavage, we’ve noticed that no response has been received from you since July 8th. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

Hi @jsavage, 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.