Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello,
I hope to calculate frequency of Loss by Threshold per Loss Year
Loss Year | ClaimRef | Loss |
2009 | 1 | 488999 |
2008 | 2 | 1002889 |
2015 | 3 | 5999753 |
2019 | 4 | 6395837 |
I hope to calculate frequency(number of claimref) where Loss Amount is greater than or equal to Thresold 500k, 1M, 1.5M....
The result table should look something like
Year Threshold | 500000 | 1000000 | 1500000 | 2000000 |
2008 | 5 | 4 | 4 | 2 |
2009 | 6 | 5 | 1 | 1 |
2010 | 2 | 2 | 1 | 0 |
2011 | 4 | 3 | 2 | 2 |
Kindly help with this.
Thank you
@amitchandak @Anonymous @parry2k @mahoneypat @AlB @lbendlin
Solved! Go to Solution.
@Anonymous ,
Would be better if you provide some data..
However, I have tried ..
Check this out the pbx file from below link
https://dropfiles.org/6v2zfFpu
Regards
sanalytics
@Anonymous Hey solution is attached, it is dynamic means you can manage the ranges in a table and everything will work as expected, there is no fixed range, so this can scale as business needs grow/change.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
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.
@Anonymous Hey solution is attached, it is dynamic means you can manage the ranges in a table and everything will work as expected, there is no fixed range, so this can scale as business needs grow/change.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
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.
Hello,
Thank you so much for helping me with this!!
I am very grateful, thank you!!
@Anonymous ,
Below Formula will also help you
Please find the pbix file from below link
https://dropfiles.org/nWtta5Xf
Regards
sanalytics
Hello,
Thank you so much for taking the time and helping me with this problem!!
Really very grateful!!
Thanks!!
Hello @sanalytics ,
Thank you so much for your help. I have modified my question to better explain what i am trying to do.
Kindly help if possible.
Thank you.
@Anonymous ,
Would be better if you provide some data..
However, I have tried ..
Check this out the pbx file from below link
https://dropfiles.org/6v2zfFpu
Regards
sanalytics
@Anonymous check this Dynamic Segmentation blog and see if that gets you what you need.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
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.
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
93 | |
93 | |
84 | |
81 | |
49 |
User | Count |
---|---|
145 | |
142 | |
111 | |
71 | |
55 |