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 everyone,
Here is my table called "Data":
Vendor | Size Group | Model | Product Number | Quantity | Cost | TAT | Posting Date |
A | S | A150 | 5 | 150 | 450 | 67 | July 7, 2018 |
A | M | A200 | 5 | 250 | 1500 | 75 | June 22, 2018 |
A | M | A150 | 5 | 25 | 8500 | 85 | July 9, 2018 |
C | L | A200 | 10 | 350 | 1250 | 125 | March 5, 2018 |
C | XL | A500 | 5 | 150 | 6500 | 45 | February 20, 2018 |
A | M | A900 | 10 | 385 | 475 | 40 | January 29, 2018 |
A | M | A150 | 5 | 650 | 45 | 45 | August 31, 2018 |
D | M | A150 | 5 | 65 | 7500 | 15 | April 10, 2018 |
D | M | A300 | 10 | 140 | 3420 | 10 | April 3, 2018 |
E | S | A150 | 15 | 20 | 10525 | 85 | January 3, 2018 |
B | S | A150 | 5 | 30 | 10500 | 40 | June 3, 2018 |
B | S | A150 | 5 | 450 | 450 | 64 | April 3, 2018 |
E | XS | A900 | 5 | 45 | 75 | 60 | January 3, 2018 |
F | M | A900 | 15 | 95 | 655 | 175 | January 3, 2018 |
D | XL | A300 | 5 | 15 | 21500 | 25 | January 3, 2018 |
D | S | A500 | 10 | 450 | 65 | 25 | May 3, 2018 |
A | M | A350 | 15 | 250 | 450 | 22 | January 3, 2018 |
B | S | A150 | 15 | 45 | 8500 | 28 | January 3, 2018 |
A | S | A300 | 5 | 550 | 650 | 128 | January 3, 2018 |
C | M | A150 | 5 | 1500 | 855 | 190 | January 3, 2018 |
B | M | A150 | 10 | 65 | 1750 | 41 | January 3, 2018 |
A | L | A500 | 15 | 75 | 1700 | 24 | January 3, 2018 |
B | S | A900 | 10 | 55 | 9800 | 37 | May 29, 2018 |
B | M | A500 | 5 | 150 | 850 | 83 | April 18, 2018 |
I was hoping to have a few Calculated Columns where:
Also, is there a way to concatenate those common items in a measure to be used as tooltip in a chart & to be used in a Card visual for example?
Can you please show me how to do this because I don't know what syntax to filter out uncommon items while retaining common ones.
Thank you so much!
Solved! Go to Solution.
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 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |