Forum Discussion
Piyush_Ghungrud
Helper I
Helper ITracking a product with launch date given country selected and non selected.
Hi Community, I am working on a Launch Tracker of products where I have data on their launch date, and sales, along with the current month and the countries where they have launched. I want to show...
lbendlin
Super User
Super UserPlease provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Piyush_GhungrudHelper I
Helper I| Product | Country | Month | Val | Launch Date | RANKing Group | rank | Test |
| Product x | France | 2021-06 | 0 | 6 | 0 | 0 | |
| Product x | France | 2021-07 | 0 | 7 | 0 | 0 | |
| Product x | France | 2021-08 | 0 | 8 | 0 | 0 | |
| Product x | France | 2021-09 | 0 | 9 | 0 | 0 | |
| Product x | France | 2021-10 | 0 | 10 | 0 | 0 | |
| Product x | France | 2021-11 | 0 | 11 | 0 | 0 | |
| Product x | France | 2021-12 | 0 | 12 | 0 | 0 | |
| Product x | France | 2022-01 | 0 | 13 | 0 | 0 | |
| Product x | France | 2022-02 | 0 | 14 | 0 | 0 | |
| Product x | France | 2022-03 | 0 | 15 | 0 | 0 | |
| Product x | France | 2022-04 | 0 | 16 | 0 | 0 | |
| Product x | France | 2022-05 | 0 | 17 | 0 | 0 | |
| Product x | France | 2022-06 | 0 | 18 | 0 | 0 | |
| Product x | Germany | 2021-03 | 0 | 3 | 0 | 0 | |
| Product x | Germany | 2021-04 | 0 | 4 | 0 | 0 | |
| Product x | Germany | 2021-05 | 0 | 5 | 0 | 0 | |
| Product x | Germany | 2021-06 | 0 | 6 | 0 | 0 | |
| Product x | Germany | 2021-07 | 0 | 7 | 0 | 0 | |
| Product x | Germany | 2021-08 | 0 | 8 | 0 | 0 | |
| Product x | Germany | 2021-09 | 0 | 9 | 0 | 0 | |
| Product x | Germany | 2021-10 | 0 | 10 | 0 | 0 | |
| Product x | Germany | 2021-11 | 0 | 11 | 0 | 0 | |
| Product x | Germany | 2021-12 | 0 | 12 | 0 | 0 | |
| Product y | France | 2020-07 | 90 | 2019-01 | 1 | 1 | |
| Product y | France | 2020-08 | 68 | 2019-01 | 2 | 2 | |
| Product y | France | 2020-09 | 5 | 2019-01 | 3 | 3 |
1. RANKing Group = RANKX(FILTER('Data','Data'[Product] = EARLIER('Data'[Product])),'Data'[Month],,ASC,Dense)
2. Test = IF(Data[rank]="0",0,Data[RANKing Group])
Please find the sample data and formulas that I used to get up to this result.
Thank you 🙂