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

 Greg_Deckler thanks for your suggestion - unique patients is a measure so it won't let me put it in a SUM; would you be willing to share your email? I have the file in dropbox and could share it with you.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Oh, just take out the SUM's then if it is already a measure. You can use a measure in another measure without an aggregation.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Greg_Deckler - the formula returns a result, but not what I'm looking for; tried a few different things with no success, not sure what the issue is. any chance I can share the file with you? 

     

    Year            UniquePts   Diff  

    20145452
    20154343
    20163231
    20173030

     

    =[Unique Patients] - CALCULATE([Unique Patients], FILTER(ALL(Table1), [ServiceDate] = MAX([ServiceDate])-1))

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      8 years ago

      Maybe something with your measure calculation, can you share your formula? 

       

      You can email me at gdeckler @ fusionalliance . com

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        thanks very much - I shared the file through dropbox; let me know if you didn't get it.

         

        here's the current formula: 

         

        =[Unique Patients] - CALCULATE([Unique Patients], FILTER(ALL(Table1), [ServiceDate] = MAX([ServiceDate])-1))