Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Mr. Miguel Escobar has written a pattern on his blog under the subject "Time Intelligence with Power Query"
brought us the same period of dates but for last year. it also featured a function like "TOTALMTD" giving an accumulative value based on month-to-date. What I'm thinking about is it would be great if both "TOTALQTD" & "TOTALYTD" could be incorporated too providing an accumulative value based on a year-to-date, quarter-to-date as well. Hopefully Miguel would like to share it with us on the forum.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.