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 everyone.
I ´m trying to set a Matrix visual to show teh acumulative values of the warehouses per month.
But all I have is the sum of the movements of the current monyh. Tried ChatGPT to solve the measure but still not works as spected:
In the image you can see the sum of the movements of each month, but I spected to see in may for example, total of April + Total of May. This is my DAX formula:
Solved! Go to Solution.
@sephirot2000
Try his measure:
suma acumulada cost amount actual =
CALCULATE (
SUM ( valueEntries[costAmountActual] ),
FILTER (
ALL ( valueEntries ),
valueEntries[postingDate] <= MAX ( valueEntries[postingDate] )
)
)
The months in the columns, are they coming from the same table as other fields or do you have a seperate date table.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@sephirot2000
Try his measure:
suma acumulada cost amount actual =
CALCULATE (
SUM ( valueEntries[costAmountActual] ),
FILTER (
ALL ( valueEntries ),
valueEntries[postingDate] <= MAX ( valueEntries[postingDate] )
)
)
The months in the columns, are they coming from the same table as other fields or do you have a seperate date table.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks a lot, your answer put me in the righ way.
I comnplete the formula with my own filters and worked very well.
Hi and thanks for the answer.
the dates came from a separate table to filter but I can set in the same table.
@sephirot2000
Please try
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Not worked as spected:
Ok my fault, I had a filter in the visual object.
The sum in now correct for the total, now I have to configure the Totals for the cells in the righ way. Thanks
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
17 | |
8 | |
7 | |
7 | |
6 |
User | Count |
---|---|
23 | |
11 | |
10 | |
9 | |
7 |