If category has been giving null everyday for past 30 days, filter out

[eliasayy]

Hello, im trying to create a measre to filter out inactive platforms

So basically i want ,if the values of this platform has been giving me null for more than 30 days from today then filter the name of the platform it out

So today is 17 january 2023, so if the platform has been giving me null everyday from december 22 2022 to january 17 2023 then filter out

[FreemanZ]

hi @eliasayy 

you mentioned date, platform and value, how are they related?

what do you expect after filtering out, SUM the values for all remaining platforms?

[eliasayy]

Hello @FreemanZ i have a table that shows values from my database that and merged it with datetable so i can have data row for everyday for each platform

I did this because i need to see if my bot is extracting data from websites of my platforms amd throwing them into my database server.

But sonetimes some platforms just stop giving me data and i dont want my slicer to be filled with so many platform that some of them arent being used.

Now for my table in power bi, 

So basically i have multiple columns in the table

Date, platform, and the rest of the columns are values like # calls made , spent, completed,transferred.

And no i dont need sum i hust need date by date for each platform if the rows of the values columns are null for 30 consecutive days until today, then i dont want the slicer to show this platform

[FreemanZ]

hi @eliasayy 

To use a field to filter data, it is always advisible to use a column. 

Not sure if i fully get you, you may try to create a column (to be used to tag idle platforms) like this:

PlatformOut = 
VAR _platform = [platform]
VAR _date = [date]
VAR _table =
FILTER(
    TableName, 
        TableName[platform]=_platform
            &&TableName[Date]<=_date
            &&TableName[Date]>=_date-30
)
RETURN
IF(
    COUNTROWS(_table)=0,
    "Out", "In"
)