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!View all the Fabric Data Days sessions on demand. View schedule
Looking to create two new columns that then give the difference between two columns, for example
different between 2021/22_22 count and 2021/2_P11 Count and then the same for mins.
Hi @Anonymous ,
There's no 2021/22_22 column in your sample, is it a column in the same table with 2021/22_P11? could you please explain it more?
Best Regards,
Community Support Team _ kalyj
@Anonymous , Do you have custom period and you want period over period time intellignece
if these are standard month
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
for custom period jump to custom section
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!