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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have 2 slicers: one choosing the year and one choosing the month (or months). I have two results: the total of the year an the total of the selected month(s):
I have the turnover of year X
I have the turnover of Months A - B - .. (minimum 1 month to maximum 12 months)
How can I now: Divide both results / sum both results etc. So avoiding measures or calculated columns?
If I can not avoid measures or calculated columns, please explain me how I can resolve this? I have next data:
table : alle afleveringen
Columns in this table = year / month / turnover
thank you
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!