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.
Hello, I am trying to group and divide some values in different tables. I attached pbix file.
There are a few campaigns with values and blank value (called other). I want to divide these "other" values to other campaigns. Other values are 2. One is should with "campaign 1" and second should be split into other values.
Why 1000 below? I count campaign 2-6 = 1000 and I divided them by percentage - it is how "probably" they lead. So it is not clear numbers, but only with probability. Most leads in the campaign - most percent from unknown campaign.
Hope, it is a little clear
BTW not sure, if it is the right way to divide unknown numbers.
Thanks in advance
Result should be:
Name | Leads |
Campaign 1 | 100 + 300 (from second table) |
Campaign 2 | 200 + 20% from1000 |
Campaign 3 | 150 + 15% from 1000 |
Campaign 4 | 200 + 20% from 1000 |
Campaign 5 | 250 + 25% from 1000 |
Campaign 6 | 200 + 20% from 1000 |
hi @Anonymous
1. why campaign 2-6 will add 1000 2000 3000 4000 5000 6000, what is the logic of it.
2. what is the logic of this percent, just a random percent between 0% and 100%?
Regards,
Lin
My mistake - divide should be number 700 instead of 1000
Number 1000 - is sum of campaign 2 to 6
I divided those campaigns by success. Then I want to divide number 700 (table: calls - other "other 2" - value 700) by percentage.
Thanks and sorry
@Anonymous ,Can you share sample data and sample output in table format?
few ways to get information from 1 table to another in a column
1-M related tables (From 1 to M) //new column Sales
Item Name = RELATED('item'[Brand])
//On Sales Side. But both side of the join is poosible
City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])
//In sales
Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])
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 |
---|---|
108 | |
98 | |
79 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |