Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Dear everybody,
i have calculated average discounts and margins by year and product.
I would like to toss years and insert two rolling periods of time to compare with each other:
last 12 months (T-12…T) and the prior 12 months (T-24…T-12)
How do i add a filter where i can pick a date and it would give me the rolling period strating from the picked date?
How can i make sure that measures are calculated on revenues from either acutal or budget but noch both at the same time?
Thank you in advance for your help.
Please see my project file with sample data under the following link
https://1drv.ms/u/s!AhqCxmrXP_AFihq3KZZ78xkT_8hg?e=oB27UC
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |