locked
Per Member Per Year Costs RRS feed

  • Question

  • Hi,

    I'm trying to get PowerBI to calculate member costs by distinct members over a period of time.  I'm trying to build an if statement that says if the the slicer named"reporting period" shows less than 12 months, then divide the costs by the months between the two dates and multiply by 12 (to get an annualized number).  But if the reporting period is greater than 12 months, then I just want the costs to be divided by the distinct members in that period.

    Here's what I'm hoping to do:

    Medical Per Member Per Year = If Reporting Period < 12 months, then [Med Cost]/[Months in Period]*12/[All Members], [Med Cost]/[Reporting Period]/[All Members]

    Help!!

    Wednesday, May 9, 2018 12:18 AM

Answers

All replies