Forum Discussion
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...
MRozeboom , Try like. based on what I got
Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER('Table', 'Table'[Initial date]+365 <=TODAY()))
MRozeboom , Try like. based on what I got
Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER('Table', 'Table'[Initial date]+365 <=TODAY()))
That is perfect mate. Worked like a charm. Thank you very much!