Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Power BI Community,
I have a data set, I want to create a cumulative monthly total bar chart.
The 2 fields I will be using are 'Payment Date' and 'USD Paid'. See the data table below
Based on this how can I represent the cumulative totals in a bar graph?
Many in thanks in advance
Solved! Go to Solution.
@JayKarim
You can create the following measure to get the cumulative total:
Cumm Total =
CALCULATE(
SUM(TableName['USD Paid']),
TableName['Payment Date'] <= MAX(TableName['Payment Date']),
REMOVEFILTERS(TableName)
)
If you have a dates table in your model, it would be better to use it, this should also work.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@JayKarim
You can create the following measure to get the cumulative total:
Cumm Total =
CALCULATE(
SUM(TableName['USD Paid']),
TableName['Payment Date'] <= MAX(TableName['Payment Date']),
REMOVEFILTERS(TableName)
)
If you have a dates table in your model, it would be better to use it, this should also work.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
94 | |
86 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |