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

     

     

     

     

MattAllington's avatar
MattAllington
Community Champion
7 years ago

This is a very complex issue that I wont go into.  The solution to your problem is to 

  1. add a calendar table 
  2. link the tables
  3. put the date from your calendar table in the visual
  4. write the same (first measure) that refers to the date in the calnedar table  - it will work.

You can learn about calendar tables in Power BI at my blog