created and deleted id between a date range

[celchar98]

I have this table loaded in Power BI. I want to create a DAX measure that reflects the following:

June 1- 5 dataflows created- 0 deleted

June 2 - no new dataflows created- 0 deleted

June 3- no new dataflows created- 0 deleted

june 4- 1 new dataflow created- 3 deleted

june 5 - 0 new dataflows created- 1 deleted

So between june 1 and june 5, 6 dataflows were created and 4 were deleted 
Please can someone help!! very appreciated. I want this logic to hold as I add more data.

[celchar98]

Thank you for your reply. 
Here is the file I am working with. 
I want to know how many dataflows were created and deleted daily. 

So I want the DAX to return the following:

On June 1:
5 dataflows created
0 deleted

On June 2:
no new dataflows were created ( because there is no new id that appeared compared to yesterday ) 
0 deleted

On June 3
no new dataflows created
0 deleted

On june 4
1 new dataflow created ( df 6) 
3 deleted

On june 5 
0 new dataflows created

1 deleted

So between june 1 and june 5, 6 dataflows were created and 4 were deleted 

Dataflow ID	Dataflow Scan ID	Dataflow Name	Dataflow scan date	Workspace ID	Workspace Name
Df1	45078 Df1	States	6/1/2023	Wk1	Carla Workspace
Df2	45078 Df2	Hospitals	6/1/2023	Wk1	Carla Workspace
Df1	45079 Df1	States	6/2/2023	Wk1	Carla Workspace
Df3	45078 Df3	Cases	6/1/2023	Wk1	Carla Workspace
Df2	45079 Df2	Hospitals	6/2/2023	Wk1	Carla Workspace
Df1	45080 Df1	States	6/3/2023	Wk1	Carla Workspace
Df1	45081 Df1	States	6/4/2023	Wk1	Carla Workspace
Df2	45080 Df2	Hospitals	6/3/2023	Wk1	Carla Workspace
Df3	45079 Df3	Cases	6/2/2023	Wk1	Carla Workspace
Df3	45080 Df3	Cases	6/3/2023	Wk1	Carla Workspace
Df4	45078 Df4	Immigration data	6/1/2023	Wk2	Chris Workspace
Df4	45079 Df4	Immigration data	6/2/2023	Wk2	Chris Workspace
Df5	45078 Df5	Immigration procedure	6/1/2023	Wk2	Chris Workspace
Df5	45079 Df5	Immigration procedure	6/2/2023	Wk2	Chris Workspace
Df5	45080 Df5	Immigration procedure	6/3/2023	Wk2	Chris Workspace
Df4	45080 Df4	Immigration data	6/3/2023	Wk2	Chris Workspace
Df4	45081 Df4	Immigration data	6/4/2023	Wk2	Chris Workspace
Df6	45081 Df6	US Immigration Data	6/4/2023	Wk2	Chris Workspace
Df6	45082 Df6	US Immigration Data	6/5/2023	Wk2	Chris Workspace
Df4	45082 Df4	Immigration data	6/5/2023	Wk2	Chris Workspace

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...