Forum Discussion

BeginnerBI's avatar
BeginnerBI
Helper I
2 years ago
Solved

Rollover

Hello colleagues,   We want to see how many accounts opened in December but excluding the ones that applied in December.   I have this DAX that brings me the opened accounts for December but I ne...
"DAX help"
"DAX"
Help
rollover
  • BeginnerBI's avatar
    BeginnerBI
    2 years ago

    Certainly, I successfully addressed this issue by creating a new column and implementing an IF statement. Thank you for your attention to this matter.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

BeginnerBI OK, so can you explain the logic here? You have 5 rows with an openaccount in December of 2024 so I am assuming that is the "Opened" metric. What I don't understand is the rollover metric. Are those the 2 rows that have an applications date that is not in December of last year?

 

If so, perhaps something like:

Rollover measure = 
  VAR __Count = COUNTROWS('Table')
  VAR __Month = MONTH(MAX('Dates'[Date]))
  VAR __Exclude = COUNTROWS(FILTER('Table', MONTH([applications]) = __Month))
  VAR __Result = __Count - __Exclude
RETURN
  __Result