Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with many rows, then I want to create a column in this table with random values: Yes, No with a ratio of 80% data for Yes - 20% data for No.
Thank you
To do this you need index field or Incremental date time column
Then you need a new column =
var _sum = sum(Table[Value])
var _cumm = calculate(sum(Table[Value]) , filter(Table, Table[Index]) <= EARLIER(Table[Index]) )
return
if(divide(_cumm,_sum), <=.8,"Yes", "No")
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
Earlier: https://youtu.be/CVW6YwvHHi8
For measure way
Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw
Your suggestion will return to Yes of 80% first of data. But I want to random value Yes and No with ratio 80% - 20%. Please view below sample
Customer ID | Yes/No |
001 | Yes |
002 | Yes |
003 | No |
004 | Yes |
005 | Yes |
006 | Yes |
007 | No |
008 | Yes |
009 | Yes |
010 | Yes |
You can use random sampling for this. The following links might help:
https://www.linkedin.com/advice/0/what-benefits-drawbacks-using-random-sampling-power
https://chandoo.org/wp/power-query-random-sample/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
52 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
76 | |
58 | |
47 | |
17 | |
12 |