Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
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!
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!
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |