add column, if a platform has blank or 0 for the past 10 consecutive days, from today, then inactive

eliasayyy — Wed, 18 Jan 2023 17:38:37 GMT

hello everyone i have a table

Date	Platform	Calls	Minutes
12/27/2022	A	10392	261
12/28/2022	A	25452	420
12/29/2022	A	11652	538
12/30/2022	A	22754	195
12/31/2022	A	28365	400
1/1/2023	A
1/2/2023	A
1/3/2023	A
1/4/2023	A
1/5/2023	A
1/6/2023	A
1/7/2023	A
1/8/2023	A
1/9/2023	A	17188	317
1/10/2023	A	26156	316
1/11/2023	A	23747	111
1/12/2023	A	12744	468
1/13/2023	A	13907	473
1/14/2023	A	24940	469
1/15/2023	A	10638	514
1/16/2023	A	28624	150
1/17/2023	A	15669	368
1/18/2023	A	14265	489
12/27/2022	B	26698	168
12/28/2022	B	16998	148
12/29/2022	B	12886	436
12/30/2022	B	26203	477
12/31/2022	B	13611	324
1/1/2023	B	22950	404
1/2/2023	B	23478	225
1/3/2023	B	17930	198
1/4/2023	B	12520	529
1/5/2023	B	16147	218
1/6/2023	B
1/7/2023	B
1/8/2023	B
1/9/2023	B
1/10/2023	B
1/11/2023	B
1/12/2023	B
1/13/2023	B
1/14/2023	B
1/15/2023	B
1/16/2023	B
1/17/2023	B
1/18/2023	B

i want to add a column that shows if call and minutes have been blank or 0 for the past 10 or more consecutive days from today, then they are inactive

result expected:

Date	Platform	Calls	Minutes	Inactive
12/27/2022	A	10392	261	No
12/28/2022	A	25452	420	No
12/29/2022	A	11652	538	No
12/30/2022	A	22754	195	No
12/31/2022	A	28365	400	No
1/1/2023	A			No
1/2/2023	A			No
1/3/2023	A			No
1/4/2023	A			No
1/5/2023	A			No
1/6/2023	A			No
1/7/2023	A			No
1/8/2023	A			No
1/9/2023	A	17188	317	No
1/10/2023	A	26156	316	No
1/11/2023	A	23747	111	No
1/12/2023	A	12744	468	No
1/13/2023	A	13907	473	No
1/14/2023	A	24940	469	No
1/15/2023	A	10638	514	No
1/16/2023	A	28624	150	No
1/17/2023	A	15669	368	No
1/18/2023	A	14265	489	No
12/27/2022	B	26698	168	Yes
12/28/2022	B	16998	148	Yes
12/29/2022	B	12886	436	Yes
12/30/2022	B	26203	477	Yes
12/31/2022	B	13611	324	Yes
1/1/2023	B	22950	404	Yes
1/2/2023	B	23478	225	Yes
1/3/2023	B	17930	198	Yes
1/4/2023	B	12520	529	Yes
1/5/2023	B	16147	218	Yes
1/6/2023	B			Yes
1/7/2023	B			Yes
1/8/2023	B			Yes
1/9/2023	B			Yes
1/10/2023	B			Yes
1/11/2023	B			Yes
1/12/2023	B			Yes
1/13/2023	B			Yes
1/14/2023	B			Yes
1/15/2023	B			Yes
1/16/2023	B			Yes
1/17/2023	B			Yes
1/18/2023	B			Yes

Re: add column, if a platform has blank or 0 for the past 10 consecutive days, from today, then inactive

Anonymous — Wed, 18 Jan 2023 18:04:04 GMT

Hello eliasayyy

Please try

New calculated column =

If(

Calculate(

count(table[platform]),

And(table[calls] = blank(),table[minutes] =blank()),

Datesbetween(table[date],today() -10,today()),

Allexcept(table,table[platform])

)>=10,

"Yes",

"No"

)

topic Re: add column, if a platform has blank or 0 for the past 10 consecutive days, from today, then inactive in DAX Commands and Tips

add column, if a platform has blank or 0 for the past 10 consecutive days, from today, then inactive

Re: add column, if a platform has blank or 0 for the past 10 consecutive days, from today, then inactive