Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Gus_C
Frequent Visitor

Annualised fee percentage by client type

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!

 

3 REPLIES 3
v-kelly-msft
Community Support
Community Support

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
Frequent Visitor

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!

Hi  @Gus_C ,

 

Is your issue solved now?

 

 

Best Regards,
Kelly

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.