Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Count rows before a given date for each row

  Hi,    I'm facing a problem with  a table in which I'd like to calculate the number of rows that exist until a given date. My table has the following structure:    Unique_identifier    Updatio...
Need Help
  • DoubleJ's avatar
    DoubleJ
    7 years ago

    You could add a calculated column (Table name is "Registries")

     

    Count = 
VAR UpdationDate = Registries[Updation_date]
RETURN
COUNTROWS(
    FILTER(Registries,Registries[Updation_date] <= UpdationDate))

    That should result in:

    Hope this helps

    JJ

     

     

     

     

DoubleJ's avatar
DoubleJ
Solution Supplier
7 years ago

You could add a calculated column (Table name is "Registries")

 

Count = 
VAR UpdationDate = Registries[Updation_date]
RETURN
COUNTROWS(
    FILTER(Registries,Registries[Updation_date] <= UpdationDate))

That should result in:

Hope this helps

JJ