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.
Hello!
I have created a measure to calculate the rolling average of the money flow from my company's funds over the last 30 days, it works beautifully, and the calculation is done for everyday. But the problem is that after slicing clients, the calculation is no longer done for every day, but only for the dates when that particular client had impact on the money flow. This reduces the usability of the rolling average chart, i only want the money flow to be sliced by client, not the dates in which the calculation is being done. Here is the code from my measure:
@Joey_ Try: Better Rolling Average - Microsoft Power BI Community
Thanks a lot for the suggestion, but that does not solve my problem. I need the rolling average to be calculated for every single day, regardless of data slicing.
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |