Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
I want a table that adds automatically new dates as columns. Always the same rows.
Do you know if it is possible?
For instance, always the same 4 metrics as rows but adding yesterday' values.
13/2:
Rows: Time, #, Speed
Columns: 10/2.11/2,12/2
14/2:
Rows: Time, #, Speed
Columns: 10/2.11/2,12/2,13/2
15/2:
Rows: Time, #, Speed
Columns: 10/2.11/2,12/2,13/2,14/2
Thanks
Hi @blitwak
As far as i know, there is no better way to achieve that.
Regards,
Cherie
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 38 | |
| 31 | |
| 27 | |
| 26 |