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 all,
I have a table which looks like below data set.
One Article can have many products based on date and Country.
As you see Product B07CN9D18C has a creation date after creation date of B0777J1KP1, so any rating after this date for B0777J1KP1 should be ignored.
Artikelnummer | Product | Country | Product_Coutry_Art | Aktiv | New rating | Creation_date | Rating_Date |
10029872 | B0777J1KP1 | DE | B0777J1KP1DE10029872 | 0 | 2 | 07/11/2017 | 13/12/2017 |
10029872 | B0777J1KP1 | DE | B0777J1KP1DE10029872 | 0 | 3.1 | 07/11/2017 | 18/12/2017 |
10029872 | B07CN9D18C | DE | B07CN9D18CDE10029872 | 0 | 0 | 25/04/2018 | 25/04/2018 |
10029872 | B0777J1KP1 | DE | B0777J1KP1DE10029872 | 0 | 3 | 07/11/2017 | 26/04/2018 |
10029872 | B0777J1KP1 | DE | B0777J1KP1DE10029872 | 0 | 2.7 | 07/11/2017 | 29/01/2019 |
10029872 | B07MCKXF9X | DE | B07MCKXF9XDE10029872 | 0 | 5 | 11/01/2019 | 25/02/2019 |
10029872 | B07MCKXF9X | DE | B07MCKXF9XDE10029872 | 0 | 2.9 | 11/01/2019 | 09/05/2019 |
10029872 | B07MCKXF9X | DE | B07MCKXF9XDE10029872 | 0 | 2.6 | 11/01/2019 | 16/07/2019 |
10029872 | B07MCKXF9X | DE | B07MCKXF9XDE10029872 | 0 | 2.4 | 11/01/2019 | 05/08/2019 |
10029872 | B07MCKXF9X | DE | B07MCKXF9XDE10029872 | 0 | 2.6 | 11/01/2019 | 23/08/2019 |
10029872 | B07YSD8DMF | DE | B07YSD8DMFDE10029872 | 1 | 0 | 07/10/2019 | 07/10/2019 |
I need the visulization like below:
Hi @Anonymous
I can't see your expected results, could you please repost it?
Also, please kindly explain "any rating after this date for B0777J1KP1 should be ignored." thanks!
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |