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.
Hi All,
I have 'Table1' with column 'Amount', 'date' which ranges from 2015/1/1 to 2019/12/31. I another table 'DateHelper' with a column 'date' which ranges from 2019/1/1 to 2019/12/31. I also have one to many relation between 'DateHelper' and 'Table1' by 'date' column. I need to calculate cumulative sum of 'Amount' with following visualization: let's take line chart, where y-axis directs to cumulative of 'Amount' and x-axis directs to 'date' column from 'DateHelper' (to repeat: Ranges from 2019/1/1 to 2019/12/31 ). I need to show cumulative sum of 'Amount' where year < 2019 for first day of the chart and from this point continue calculation of cumulative sum.
Solved! Go to Solution.
You may add the following measure.
Measure =
CALCULATE (
SUM ( Table1[Amount] ),
FILTER ( ALLSELECTED ( Table1 ), Table1[Date] <= MAX ( DateHelper[Date] ) )
)
You may add the following measure.
Measure =
CALCULATE (
SUM ( Table1[Amount] ),
FILTER ( ALLSELECTED ( Table1 ), Table1[Date] <= MAX ( DateHelper[Date] ) )
)
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |