Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Bootstrapping - Statistical Method

Hi, I've got a very large set of data (let's say it's about attendence at schools during covid), which I've done some analysis on to determine rates of change of the attendence of students from day t...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Sorry for that DAX does not currently have the function to repeat a formula in a loop. You can consider using other statistical software such as SAS, SPSS.

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

benfedit's avatar
benfedit
Icon for Advocate I rankAdvocate I
5 years ago

Hi  Anonymous 

 

I actually happened to have written a post in my blog about implementing bootstrap sampling in Power BI.

For the "sort of" loops, I used the generateseries function which allows me to create multiples sample with replacements and also to define the size of my sample.

Here is my post:

https://datakuity.com/2021/02/15/bootstrap-analysis-with-power-bi/

 

With regards to the performance, I tested only on a small sample of about 100k rows so I'd be very interested to know how it goes on a large sample.

 

Feel free to reach out if you any questions or want to discuss it 

 

Ben