calculating column from other columns

[One-Dash]

Hello! 

I'm trying to create a visual that shows amount/count  of IDs left at the end of each day that were not QCed

here is the sample table below.    have this table related with Date table using the Date column

what i'm hoping to do is ...

For each day ,  i want to see how many ID's are left that are not QCed.  the  starting number  is going to be 25  since we have that many in backlog not QCed .....in other words I'm hoping to make the column show what ever is left  (25) + received - QC for every day . .  .    any suggestion is appreciated. Thanks

Date	ID	Received Date	QC Date	???
1/1/2022	DY12345	1/1/2022	1/1/2022	25
1/2/2022	DY12346	1/1/2022	1/1/2022
1/3/2022	DY12347	1/1/2022	1/2/2022
1/4/2022	DY12348	1/2/2022	1/2/2022
1/5/2022	DY12349	1/3/2022	1/3/2022
1/6/2022	DY12350	1/3/2022	1/4/2022
1/7/2022	DY12351	1/3/2022	1/7/2022
1/8/2022	DY12352	1/3/2022	1/8/2022
1/9/2022	DY12353	1/4/2022	1/9/2022
1/10/2022	DY12354	1/4/2022	1/9/2022
1/11/2022	DY12355	1/4/2022	1/10/2022
1/12/2022	DY12356	1/4/2022	1/11/2022
1/13/2022	DY12357	1/4/2022	1/12/2022
1/14/2022	DY12358	1/4/2022	1/13/2022
1/15/2022	DY12359	1/5/2022	1/14/2022
1/16/2022	DY12360	1/5/2022	1/15/2022

[vapid128]

Value is the date.

And your data is going down,

Is it because you have many line with no  QC Date?

[One-Dash]

yes, i have a lot of entries with no QC date , since lot of them have not been QCed.  but that's what i want to capture. .. that is  "how may count of IDs i have for each date that have not been QCed".  as each day goes by i should have lot more because i will get what ever is rolled over from the previous date.  thanks 

[vapid128]

add colnum:

new QC date =

if([QC date] >0,[QC date],TODAY())

Table22 = GENERATE(Table11,GENERATESERIES(int(Table11[Received Date]),int(Table11[new QC Date])-1))

[One-Dash]

I tried that one,  the count didn't do down like the firts one,   but the numbers are still slightly higher than what's in my Data.  the last date entry in the visual for example has 541,  but that number should have been 395.  maybe i'm missing some filters i need to apply. 

[vapid128]

Table22 = GENERATE(Table11,GENERATESERIES(int(Table11[Received Date]),int(Table11[QC Date])-1)) 

[One-Dash]

what is the value column doing?  i did the visual and it shows the id count going down when in reality i know they  have actually stayed high