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
diogobraga2's avatar
diogobraga2
Icon for Helper IV rankHelper 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
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 🙂