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! It's time to submit your entry. Live now!
Hi All,
I have data like below table.
Source of data - Excel
Req - calculate current year current month of A,B,C
Month-valA,valB,valC;2022-00,0.20,0.90,0.40;2022-01,0.20,0.90,0.40,2022-03,0.20,0.90,0.40
Data month is in Year-month format.
Thanks,
Smartnag
@Smartnag , Can paste it in table format. And provide source vs output needed
How to paste data on community
| User | Count |
|---|---|
| 50 | |
| 43 | |
| 36 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 139 | |
| 129 | |
| 61 | |
| 59 | |
| 57 |