Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I'm trying to do some visuals for some projects I'm working on, where I have a Target for the project which is static, and a monthly update of what has been invoiced.
So far I've added the data to PowerBI, created a date table and linked the projectnumbers with relations.
What I would like to do is see how much of the TargetBudget has Invoiced used on a montly basis. My issue is I can't really figure out how do I calculate the remaining budget based on what has been invoiced?
What I'm aiming at/near, when I'm finished is something similar to this Dashboard layout:
Solved! Go to Solution.
@FoolzRailer , Make sure both table are joined to common project table. No need to join target to date table
remaining example
sumx(project, calculate(Sum(Invoice[Amount]) - Sum(Target[Amount]) ) )
or
sumx(values(project[project]) , calculate(Sum(Invoice[Amount]) - Sum(Target[Amount]) ) )
@FoolzRailer , Make sure both table are joined to common project table. No need to join target to date table
remaining example
sumx(project, calculate(Sum(Invoice[Amount]) - Sum(Target[Amount]) ) )
or
sumx(values(project[project]) , calculate(Sum(Invoice[Amount]) - Sum(Target[Amount]) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |