Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
Does anyone have an idea how to calculate remaining budget as in the case below? I have data for monthly use and the overall budget.
Month | Monthly use | Remaining budget |
January | 0 | 50 000 |
February | 16 000 | 34 000 |
March | 5 000 | 29 000 |
Thank you in advance! 🙂
Julia
Solved! Go to Solution.
@Anonymous , Where is overall budget in table or it static number?
If you have date you can create cummulative sum and subract from budget
example
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
Target Amt= sumx(allselected(Target),Target [Target])
remaining = [Target Amt] -[Cumm Sales]
Hi, @Anonymous
Please check the below picture and the sample pbix file's link down below.
Remaining Budget =
VAR budgetamount = 50000
VAR monthlyusecumulate =
SUMX (
FILTER ( ALL ( 'Table' ), 'Table'[Month No] <= MAX ( 'Table'[Month No] ) ),
'Table'[Monthly use]
)
RETURN
budgetamount - monthlyusecumulate
https://www.dropbox.com/s/5mg5c2a7nsr8k9a/julkku.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
Please check the below picture and the sample pbix file's link down below.
Remaining Budget =
VAR budgetamount = 50000
VAR monthlyusecumulate =
SUMX (
FILTER ( ALL ( 'Table' ), 'Table'[Month No] <= MAX ( 'Table'[Month No] ) ),
'Table'[Monthly use]
)
RETURN
budgetamount - monthlyusecumulate
https://www.dropbox.com/s/5mg5c2a7nsr8k9a/julkku.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Anonymous , Where is overall budget in table or it static number?
If you have date you can create cummulative sum and subract from budget
example
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
Target Amt= sumx(allselected(Target),Target [Target])
remaining = [Target Amt] -[Cumm Sales]
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
13 | |
11 | |
10 | |
7 | |
6 |
User | Count |
---|---|
13 | |
12 | |
12 | |
9 | |
8 |