Forum Discussion

MRozeboom's avatar
MRozeboom
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Calculate count based on date column while adding 365 days

Hi all,   I'm trying to build a report that includes a card showing a count of expired dates. The report is based on a SharePoint list where the actual expiration date is a calculated value, making...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    MRozeboom , Try like. based on what I got

    Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER('Table', 'Table'[Initial date]+365 <=TODAY()))

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

MRozeboom , Try like. based on what I got

Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER('Table', 'Table'[Initial date]+365 <=TODAY()))

  • MRozeboom's avatar
    MRozeboom
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    That is perfect mate. Worked like a charm. Thank you very much!