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.
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