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")
Anonymous's avatar
Anonymous
Not applicable
3 years ago

AllisonKennedy 
Im bumping this question and wondering if theres something else besides a measure to use for a solution.
I have seen that I cannot use the measurement in all the visuals that I'd like.

I want to have a slicer button for yes/no that filters visuals based on the above measure or inactive filter. 

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    3 years ago

    Anonymous  Are you using import or direct query? If Import, you can use the same formula as a new column and that can be used as a slicer (if I understand what you're asking correctly?)

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      AllisonKennedy I am getting the data through web/api. 


      With this in a new column it aint working. In a measure it is working

      Inaktiv2 =
      VAR _LastDate = MAX('sub_info'[Senast aktiv]) + 0
      VAR _CutoffDays = 365
      VAR _DaysSinceLastUsed = DATEDIFF( _LastDate, TODAY(), DAY)
      RETURN
      IF(_DaysSinceLastUsed > _CutoffDays, "Inaktiv")
      • AllisonKennedy's avatar
        AllisonKennedy
        Community Champion
        3 years ago

        Anonymous  Since it's a column you won't need the MAX anymore for the date: 

         

        Inaktiv2 =
        VAR _LastDate = 'sub_info'[Senast aktiv] +0
        VAR _CutoffDays = 365
        VAR _DaysSinceLastUsed = DATEDIFF( _LastDate, TODAY(), DAY)
        RETURN
        IF(_DaysSinceLastUsed > _CutoffDays, "Inaktiv")