Counting rows from incrementing date

[damj]

Hi 

Is there a way to count rows from a specific date ( say 1/9-2019 ) to today ( 19/9-2019 ) incrementing by each day?

adding some filter.

principle is shown in figure below, but should be performed in existing table not a new like illustrated in the figure in the bottom. 

Bear in mind the table i want to count the rows is the existing table  which look like this.

hope you guys can help.

[Icey]

Hi @damj ,

You can create a Date Table like so:

Date Table = CALENDAR ( DATE ( 2019, 1, 1 ), TODAY () )

Then, create a column in Date Table.

Column = 
CALCULATE (
    COUNTROWS ( 'Table' ),
    'Table'[Oprettet_rev] >= DATE ( 2019, 9, 1 )
        && 'Table'[Oprettet_rev] <= EARLIER ( 'Date Table'[Date] )
)

And you can also create a measure like so:

Measure = 
CALCULATE (
    COUNTROWS ( 'Table' )+0,
    'Table'[Oprettet_rev] >= DATE ( 2019, 9, 1 )
        && 'Table'[Oprettet_rev] <= TODAY ()
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[damj]

Hi @Icey .

its not possible to calculate without having to generate a new table?

I wanna be able to count for each day within the existing table. 

[Icey]

Hi @damj ,

Maybe you can try this: 

Column 2 = 
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Oprettet_rev] >= DATE ( 2019, 9, 1 )
            && 'Table'[Oprettet_rev] <= EARLIER ( 'Table'[Oprettet_rev] )
    )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[damj]

@Icey  is it possible to relate to the external calender  through the earlier function?

to achive a count for each day.