The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello!
I need to calculate a sample size based on the row count of a filtered table.
I'm trying to automate part of our bad debt estimation process. I currently pull about 20 aging reports, then filter the table, take the row count and put it into an online calculator to get the sample size - then do some more filtering using RANDOM in Excel to get a sample table that is then analyzed for bad debt.
I've pulled all of my reports into P BI and want to use the SAMPLE function to get my table, but I want ot calculate the sample size based on the row count of the filtered table. does anyone know how to do that?
Here are some parameters that I enter into the online calculator...
I'm filtering my table by company and aging >90...
I'm a personal Power Bi Trainer I learn something every time I answer a question
The Golden Rules for Power BI
Help when you know. Ask when you don't!
Kim
Thanks for your feedback. Statistics is one of my weak points.
Will reconsider my extended tag line.
Ken Tyler
Help when you know. Ask when you don't!
yes, stats isn't a strong point for me either... thank you for taking the time to respond.
Kim
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |