Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Previous year DAX measure

Hi - I'm trying to create a measure that calculates the previous year's value i.e. for 2015 it would show 346 (6617-6271).    I've tried SAMEPERIODLASTYEAR and PARALLELPERIOD with no success - the ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    resolution in case it helps someone else: 

     

     

    PatientsRaw = table name

     

    Unique Patients = DISTINCTCOUNT(PatientsRaw[PersonID])

     

    UniquePatientDiff = [Unique Patients] - CALCULATE([Unique Patients],FILTER(ALLEXCEPT(PatientsRaw,PatientsRaw[PayorName]),[CalendarYear]=MAX([CalendarYear])-1))

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi - I'm trying to create a measure that calculates the previous year's value i.e. for 2015 the value would be 6617-6271 = 346

 

I"ve tried using SAMEPERIODLASTYEAR as well as PARALLELPERIOD and can't get either to work. The "year" columns is a result of the automatic date separation that PowerPivot does - it's called ServiceDate(Year) in the field list and comes from a single "ServiceDate" field. Hoping someone can help me out with this, thanks in advance!

 

 

Year      Unique Patients

20146,271
20156,617
20166,544
20176,118
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago
    PatientDiff = SUM(Patients[Unique Patients]) - CALCULATE(SUM(Patients[Unique Patients]),FILTER(ALL(Patients),[Year]=MAX([Year])-1))