Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a measure calculated over a span of time but only need to most recent span of data.
How can I keep a date filter but not have the data all be summed?
Thanks
Solved! Go to Solution.
Hi,
Please try to use 'Relative date filtering':
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
Please try to use 'Relative date filtering':
Hope this helps.
Best Regards,
Giotto Zhi
@Anonymous
Here is a link to a solution on this site that might meet your needs.
Hi @Anonymous ,
how do you define the most recent span of data?
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |