Forum Discussion

The_Clam's avatar
The_Clam
Icon for Helper I rankHelper I
5 years ago
Solved

Value Repeating within Last 15 Days

Hi.  I have data with 3 columns...ID, AlarmName, Date Created.  I need to count how many times an AlarmName repeats within the last 15 days.  Please help.  Thanks!   Sample data: ID            ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    The_Clam , Please try this with help from date table

    Rolling 14 = CALCULATE(count(Table[ID]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date]),-14,DAY))

     

    This will be for selected date or each date in trend 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

The_Clam , Please try this with help from date table

Rolling 14 = CALCULATE(count(Table[ID]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date]),-14,DAY))

 

This will be for selected date or each date in trend 

  • The_Clam's avatar
    The_Clam
    Icon for Helper I rankHelper I
    5 years ago

    That worked!  Thanks so much!