Annualised fee percentage by client type

[Gus_C]

Hi All,

I want to replicate the following excel formula into powerbi:

(sales revenue/(Num. of days per month)*365)/AVERAGE of sales between current month and one before

I have this measure which works fine but does not take average of sales between current month and one before, but just sales of current month. Also, does not use number of days per month/365 but just 12 instead, so for some months is not entirely accurate. 

I would like to display this annualised measure in a line chart per client type A and B.

I have tried adding client type for column series to no avail so thinks it needs to be embedded inside the measure?

Appreciate any help!

[v-kelly-msft]

Hi  @Gus_C ,

Could you pls provide some sample data with expected output for test?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[Gus_C]

would like to add, my dataset contains a column for number of days per month, so wondering how I can integrate this into my measure. Thanks!

[v-kelly-msft]

Hi  @Gus_C ,

Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!