Learning resources about disconnected date tables

[AntrikshSharma]

@Jamie

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…

Obtaining data for different data periods

@JoaoMonteiro As Brian has suggested here disconnected table is the way to go, and here is another way to do it. [image] Measure = VAR CurrentMaxYear = CALCULATE ( MAX ( DisDates[Calendar Year Number] ), ALLSELECTED ( DisDates ) ) VAR PrevYear = CALCULATE ( MAX ( DisDates[Calendar Year Number] ), DisDates[Calendar Year Number] < CurrentMaxYear, REMOVEFILTERS ( DisDates ) ) VAR CurrentMonth = MONTH ( TODAY () ) --Replace with your own criteria of calcula…

Show Last Year’s First 2 Months + This Year’s Current Month | Part 1 | Power BI DAX