Forum Discussion
created and deleted id between a date range
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.
2 Replies
- lbendlin
Super User
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-Forum/ba-p/963216
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/1447523 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 deletedOn June 2:
no new dataflows were created ( because there is no new id that appeared compared to yesterday )
0 deletedOn June 3
no new dataflows created
0 deletedOn june 4
1 new dataflow created ( df 6)
3 deletedOn june 5
0 new dataflows created1 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
