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.
Dear all,
I want to create a table by replacing the values in country field if the segment is for instance "S01" but I don't know how to proceed.
here below my current function :
GROUPBY(SELECTCOLUMNS(V_MARGIN;"SEG";RELATED(V_SEGMENT_GROUP[SEGMENT_GROUP_DESCRIPTION_BIS]);"CTRY";RELATED(V_CUSTOMER_FORECAST[#COUNTRY]));[SEG];[CTRY])
In advance thanks for your help
Is your current formula correct?
It seems incorrect.
Could you show me some examples for better analysis?
For example,
you have three tables involved in the "groupby" function,
show a little data of these three tables and show me expected result table based on those tables.
Best Regards
Maggie
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |