Forum Discussion
Running total in Power Pivot based on other measure with missing values in certain months
Hi Greg, thanks for your quick response. I tried this in PowerPivot but only get a blank cells. May I ask you please for PowerPivot solution or modify and attach my original xls file?
Community ChampionPivotRiot I got what appears to be a running total. Had to rewire a bunch of underlying measures. See attached below signature.
Hi Greg,
not sure, I get what solution do you propose in the attached file. What modification to the measures [RT Sales1] or [RT Sales2] can you propose to make it look like in the column *What I need:* I have added manually.
The [AvgPrice 2023] and the [RT Sales1] measures are calculated first by product A and B in separate pivot table.
So [RT Sales1] works correctly by product, but doesn't work by product by month together.
Greg_Deckler Thanks for your contribution on this thread.
Hi PivotRiot ,
Did you get the solution? If no, could you please provide some sample data (exclude sensitive data) with Text format and the calculation logic of measure [AvgPrice 2023], [RT Sales1] and [What I need] with the speicial examples and screenshot? It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
And it is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
In addition, you can refer the following links to try to solve your problem...
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dax for Power BI: Fixing Incorrect Measure Totals
Best Regards