Forum Discussion
Creating a New Measure based on MTD or YTD
Hello, Below are photos for a problem. How could I count a running total for the Number of Surveys received a) month to date and b) year to date? I have tried the code below but it is not working: ...
Anonymous Hard to tell what is going on without sample data and more formulas but try this:
Better RT =
VAR __Date = MAX('All survey data'[Date])
VAR __Table = FILTER(ALLSELECTED('All survey data'), [Date] <= __Date)
RETURN
COUNTROWS(__Table)