Showing new entries in a dataset

[deanbland]

Hi, 

I have a dataset that looks like this (ignore the 'New Entry?' column, that is the final out put I am wanting): 

Risk ID	Date	New Entry?
R1	21/06/2021
R2	21/06/2021
R1	28/06/2021
R2	28/06/2021
R3	28/06/2021	1
R4	28/06/2021	1
R1	05/07/2021
R2	05/07/2021
R5	05/07/2021	1

I am wanting to count every new entry per week but unsure how to action this. 

The data will be represented in a column chart with the X axis representing each week. The data should read 

21/06/2021 New Entries = 0

28/06/2021 New Entries = 2 (R3 & R4)

05/07/2021 New Entries = 1 (R5)

If further clarification is needed let me know. 

Thanks, 

Dean

[Fowmy · Accepted solution]

@deanbland 

Use the following measure:

New Entry = 

var __currentweek = SELECTEDVALUE(Table1[Date]) 
var __currentids = VALUES(Table1[Risk ID])
var __pastids = 
    CALCULATETABLE(
        VALUES(Table1[Risk ID]),
        Table1[Date] < __currentweek,
        ALL(table1)
    )
var __newids = 
    COUNTROWS( FILTER( __currentids , not Table1[Risk ID] IN __pastids ) )

return
    IF( NOT(ISEMPTY(__pastids)), __newids )+0