I'm learning a great deal from these window function videos. Its great to understand what's going on before diving in and starting to use them in my own reports. You have structured your examples really clearly so they are easy to follow and understand. Many thanks.

Thanks for the video! This is very helpful :) I'm wondering how to apply this to my case, where I have a calendar table, dim table and two fact tables. I would like to calculate the running total of a measure that sum values from both fact tables and having the dates and the dim in the table. Would it be possible to get this to work? Thanks!!

very well explained.....thanks

Hi I tried your DAX measure to calculate running total in my model but it does not work! So I went backwards and use 1, ABS in both positions to see if I get the first value everywhere and surprisingly even doing that, I am getting the values for each row item. Any idea what could be wrong?

lovely video, you can get the file

Great Video and thanks for your effort But please fix the mic I had a hard time hearing you.

Hello. I have a problem with this measure that I can't understand. This measure works very well: SUMX ( WINDOW ( 1, abs, 0, rel, SUMMARIZE ( ALL ( 'FACT_SALES' ), 'DIM_PRODUCT'[DIM_PRODUCT_ID], "@sum", [Sales Netto PLN]) ,ORDERBY([@SUM], desc)), [@sum] ) But this doesn't: SUMX ( WINDOW ( 1, abs, 0, rel, SUMMARIZE ( ALL ( 'FACT_SALES' ), 'DIM_PRODUCT'[DIM_PRODUCT_ID], "@sum", [Sales Netto PLN xTD) ,ORDERBY([@SUM], desc)), [@sum] ) The difference is that measure Sales Netto PLN is a classic sum measure nad sales netto pln xTD is a "to date" measure. It means that it sums sales but within a period chosen on a slicer (date range between SALES_DATE_ID from FACT_SALES). I can't get it to work.