topic Re: calculating column from other columns in DAX Commands and Tips

calculating column from other columns

One-Dash — Fri, 15 Jul 2022 18:52:12 GMT

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

Re: calculating column from other columns

vapid128 — Fri, 15 Jul 2022 19:30:40 GMT

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

Re: calculating column from other columns

One-Dash — Mon, 18 Jul 2022 12:46:06 GMT

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

Re: calculating column from other columns

vapid128 — Mon, 18 Jul 2022 22:50:10 GMT

Value is the date.

And your data is going down,

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

Re: calculating column from other columns

One-Dash — Wed, 20 Jul 2022 10:43:45 GMT

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

Re: calculating column from other columns

vapid128 — Wed, 20 Jul 2022 17:37:20 GMT

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))

Re: calculating column from other columns

One-Dash — Thu, 21 Jul 2022 11:36:54 GMT

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.