Formula for total items minus total complete for a given day.

PeteyG — Mon, 01 Jul 2024 18:34:46 GMT

I am trying to figure out the DAX for a measurement that when ploted on a line graph against a Date table named "Date" would give you the total Activities remaining. The below data would give you 20 Activities remaining before 3/8/2022. On 1/2/2023 there would be 14 activities remaining. If you looked at the link chart for June 30th 2024 there would be 6 activities remaining. It can be end of month if that is easier.

Activity ID	BL Finish
ACT-Con-001	3/8/2022
ACT-Con-002	3/11/2022
ACT-Con-003	7/14/2022
ACT-Con-004	11/16/2022
ACT-Con-005	11/19/2022
ACT-Con-006	1/22/2023
ACT-Con-007	3/27/2023
ACT-Con-008	5/30/2023
ACT-Con-009	8/2/2023
ACT-Con-010	10/5/2023
ACT-Con-011	12/8/2023
ACT-Con-012	2/10/2024
ACT-Con-013	4/14/2024
ACT-Con-014	6/17/2024
ACT-Con-015	8/20/2024
ACT-Con-016	10/23/2024
ACT-Con-017	12/26/2024
ACT-Con-018	2/28/2025
ACT-Con-019	5/3/2025
ACT-Con-020	7/6/2025

Re: Formula for total items minus total complete for a given day.

VN999 — Mon, 01 Jul 2024 23:28:16 GMT

Assuming here in DAX measure activty remaning table is named Activities and your Date table is named Date:

Activities Remaining =
VAR CurrentDate = MAX('Date'[Date])
RETURN
CALCULATE(
COUNTROWS('Activities'),
FILTER(
'Activities',
'Activities'[BL Finish] >= CurrentDate
)
)

topic Formula for total items minus total complete for a given day. in DAX Commands and Tips

Formula for total items minus total complete for a given day.

Re: Formula for total items minus total complete for a given day.