Forum Discussion

diogobraga2's avatar
diogobraga2
Icon for Helper IV rankHelper IV
6 years ago

Remove values after current date from previous years

The goal is to remove values after current date (most recent in this sample) from previous years for comparison purposes. Any insights?
Need Help
JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago
In the MAXX statement, you want to get the MonthDay from the ApplicationCount table.
diogobraga2's avatar
diogobraga2
Icon for Helper IV rankHelper IV
6 years ago

Thanks so much. Still not working, but we are getting close.

 

This is the calculated field in effect:

Measure = 
VAR maxCurrentYear = MAXX(FILTER(application_count, application_count[academic year] = "2019-2020"), application_count[MonthDay])
RETURN
IF(HASONEVALUE('Dates Adj'[Date]) && AVERAGE('Dates Adj'[MonthDay]) > maxCurrentYear, 
    BLANK(), 
    application_count[Total Apps])
  • JarroVGIT's avatar
    JarroVGIT
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    What column from which table do you use for the Matrix columns? (That should be 'Dates Adj'[Date])

    • JarroVGIT's avatar
      JarroVGIT
      Icon for Resident Rockstar rankResident Rockstar
      6 years ago

      Otherwise, feel free to PM me a link to your PBIX and I will have a closer look for you 🙂