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 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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |