Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
VertuoConseil
New Member

Generate a sample using multiple criteria

Hi there.

I have a data base with over 150 columns and around 150k rows, and I need to generate samples of 15k rows that would respect a certain nombre of rules.

For example, i have columns called 'Gender', 'Age', 'Network', and I need to generate a sample of 15k rows that would respect the following criteria : 50% of Gender=M, 50% of gender=F, 20% of Age=30...etc...

Is there a way to do do in power bi ?

 

Thank you

2 REPLIES 2
Anonymous
Not applicable

Hi @VertuoConseil

 

Do you want to apply filter befor importing data to desktop?

Hi @Anonymous .

Thanks for your answer.

No, the database has already been imported in desktop. The sample needs to be generated inside desktop.

Thank you.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.