Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Count of Value Combinations That Appear In Previous Rows

Hello PBI Community! I've been trying to work out a way to count how many times a rows combination of values appears in previous rows based on that specific rows entries but I'm hitting a wall...   ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Can you paste as text? But essentially:

    Column = COUNTROWS(FILTER('Table',[Column]=EARLIER([Column]) && [Column1] = EARLIER([Column1]) && [Some Column] = "TRUE"))

     

    Something along those lines.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Just an update to this, I think I was making it harder on myself than it needed to be haha. I ended up using a reference column that marks 1 for those paid and then used an expression like below to sum these values for each code pair/row:

Reference Column = IF( [Column3] = TRUE, 1, 0 )

           

Expression = 

       CALCULATE(

                    SUM( [Reference Column] ) ,

                    FILTER( 'Table', [Column1] = EARLIER( [Column1] ) && [Column2] = EARLIER( [Column2])

     )

 

Thanks again for the help Greg_Deckler!