Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter based on date

Hello, I have a set of data with subscriptions and there I have a column with date & time that shows when the subscription last was used.   The date column/data originally showed date and time but ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    3 years ago

    You could create a Measure similar to the below and filter for "unused" only

    Inactive Filter =
    VAR _LastDate = MAX('Table'[Date]) + 0
    VAR _CutoffDays = 365
    VAR _DaysSinceLastUsed = DATEDIFF( _LastDate, TODAY(), DAY)
    RETURN
    IF(_DaysSinceLastUsed > _CutoffDays, "Unused")
AllisonKennedy's avatar
AllisonKennedy
Community Champion
3 years ago

You could create a Measure similar to the below and filter for "unused" only

Inactive Filter =
VAR _LastDate = MAX('Table'[Date]) + 0
VAR _CutoffDays = 365
VAR _DaysSinceLastUsed = DATEDIFF( _LastDate, TODAY(), DAY)
RETURN
IF(_DaysSinceLastUsed > _CutoffDays, "Unused")
Anonymous's avatar
Anonymous
Not applicable
3 years ago

AllisonKennedy
I think that almost works actually. But are measurements not used on side filters? So that all lists on the report page are automatically filtered by the measurement. 

Maybe if I explain more about what I want to do.
I have thousands of mobile plans/subscriptions and from my operatator I can get the date it was last used.
I want to be able to in a whole report page me able to add this measurement or whatever is needed to only show the ones that have nothing filled in the date last used column or havent been used in a year or older.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I solved it by creating a new column with the measurement. I learned something new.

    Thanks AllisonKennedy !