Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I need the help with a formula to calculate the average of the clicked rate per year... example:
Date Sent Clicked
10/1/2015 250 10
11/2/2015 152 30
03/5/2016 100 50
06/05/2016 125 12
02/01/2017 200 10
09/05/2018 182 35
Any help will be greatly appricated.
Solved! Go to Solution.
@nawlins In modelling table change the format of this new measure to % and that will do it. We dont need to change anything in the formula itself.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@nawlins you can do it in many ways
Avg Rate = VAR totalSent = SUM( Table1[Sent]) VAR totalClicked = SUM( Table1[Clicked]) RETURN DIVIDE( totalSent, totalClicked, 0 )
Drop a matrix visual
- drop date column and this Avg Rate measure. You will see date have hierarchay with year as first level, above measure will work depending on which level you are in hiearchay.
Hope it is helpful.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you, parry2k. This is very helpful. Is there a way to change the solution to the formula to display as a percentage % ?
@nawlins In modelling table change the format of this new measure to % and that will do it. We dont need to change anything in the formula itself.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
90 | |
82 | |
76 | |
64 |
User | Count |
---|---|
144 | |
109 | |
108 | |
100 | |
96 |