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 all!
I have a a dataset such as:
Type | Value | Month |
Income | 123 | Jan |
Expense | 321 | Feb |
Other | 456 | Mar |
I'd like to sum all incomes per month as well as expenses.
Once i do that i'll be able to substract Income-Expense and display a burndown chart of the finances.
Any help would be appreciated on how to best achieve it.
Thanks in advance!
Solved! Go to Solution.
Hi @Markie
You can create three measures and put them as well as the Month column into a table visual to check the sum result.
Incomes Total = CALCULATE(SUM('Table'[Value]),'Table'[Type]="Income")
Expenses Total = CALCULATE(SUM('Table'[Value]),'Table'[Type]="Expense")
Remains = [Incomes Total] - [Expenses Total]
You can put these measures in other visuals later.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hi @Markie
You can create three measures and put them as well as the Month column into a table visual to check the sum result.
Incomes Total = CALCULATE(SUM('Table'[Value]),'Table'[Type]="Income")
Expenses Total = CALCULATE(SUM('Table'[Value]),'Table'[Type]="Expense")
Remains = [Incomes Total] - [Expenses Total]
You can put these measures in other visuals later.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |