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.
HI
I need some help.
I have a table below.
Year | Month | Day | Product | Type | Group | Price |
2019 | 3 | 1 | A | Own | First Group A | 100 |
2019 | 3 | 1 | B | Competitor | First Group A | 120 |
2019 | 3 | 1 | C | Own | First Group B | 90 |
2019 | 3 | 1 | D | Competitor | First Group B | 80 |
2019 | 3 | 5 | E | Own | First Group C | 150 |
2019 | 3 | 5 | F | Competitor | First Group C | 170 |
2019 | 3 | 7 | G | Own | First Group D | 150 |
2019 | 3 | 7 | H | Competitor | First Group D | 120 |
and I would like to show the competitor price in every group itself.
Below is the measure I use and the expected result that I want to archive. Please advise.
Year | Month | Day | Product | Type | Group | Price | Competitor Price |
2019 | 3 | 1 | A | Own | First Group A | 100 | 120 |
2019 | 3 | 1 | B | Competitor | First Group A | 120 | 120 |
2019 | 3 | 1 | C | Own | First Group B | 90 | 80 |
2019 | 3 | 1 | D | Competitor | First Group B | 80 | 80 |
2019 | 3 | 5 | E | Own | First Group C | 150 | 170 |
2019 | 3 | 5 | F | Competitor | First Group C | 170 | 170 |
2019 | 3 | 7 | G | Own | First Group D | 150 | 120 |
2019 | 3 | 7 | H | Competitor | First Group D | 120 | 120 |
Solved! Go to Solution.
Hi @AlwaysBI
You can create a calculated colum in the table you show (Table1):
Competitor Price = CALCULATE ( DISTINCT ( Table1[Price] ); ALLEXCEPT ( Table1; Table1[Group] ); Table1[Type] = "Competitor" )
Hi @AlwaysBI
You can create a calculated colum in the table you show (Table1):
Competitor Price = CALCULATE ( DISTINCT ( Table1[Price] ); ALLEXCEPT ( Table1; Table1[Group] ); Table1[Type] = "Competitor" )
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 |