Forum Discussion

diogobraga2's avatar
diogobraga2
Helper 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
Resident Rockstar
6 years ago
In the MAXX statement, you want to get the MonthDay from the ApplicationCount table.
diogobraga2's avatar
diogobraga2
Helper 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
    Resident 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
      Resident Rockstar
      6 years ago

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