Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |