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
diogobraga2's avatar
diogobraga2
Helper IV
6 years ago

JarroVGIT  thanks for the prompt reply. For the date fields in the calcuation, do I have to use the Calendar table? Right now I am, and I am getting the error message below. What do you think is going on? 

 

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 🙂