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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have monthly data from few years and i need to compare this years months with selected year for e.g.
2023/1 with 2019/1
and so on until i reach the maximum months that i have of current year, right now i have until 2023 august
in your pbi result is
when i put my data in i get
you get 8 months i get 12
pls try this code
how does it work? if i select sales and months should it be all 12? sales is just sum(data[value]) why it calculates just the 8?
i get the right year but too many months
what do many months mean?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.