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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |