Cumulative by Selected Month & Year

[AntrikshSharma]

@Hesham In scenarios like these, disconnected date table is the only option. Read here why:

Cumulative Transactions

As Greg rightly said you would need a disconnected table for this, the logic behind this is that: behind the scenes SUMMARIZECOLUMNS prepares the matrix and when you have a selection on a slicer then that code will filter query generated by SUMMARIZECOLUMNS, which will result in only those months that are selected in a slicer. Before your DAX code in PBI starts working, SUMMARIZECOLUMNS has completed its task and gives you a matrix visual on which your DAX code has to work/iterate, so in orde…