Forum Discussion

Piyush_Ghungrud's avatar
Piyush_Ghungrud
Icon for Helper I rankHelper I
3 years ago

Tracking 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...
Need Help
  • Piyush_Ghungrud's avatar
    Piyush_Ghungrud
    Icon for Helper I rankHelper I
    3 years ago
    ProductCountryMonthValLaunch DateRANKing GrouprankTest
    Product xFrance2021-060 600
    Product xFrance2021-070 700
    Product xFrance2021-080 800
    Product xFrance2021-090 900
    Product xFrance2021-100 1000
    Product xFrance2021-110 1100
    Product xFrance2021-120 1200
    Product xFrance2022-010 1300
    Product xFrance2022-020 1400
    Product xFrance2022-030 1500
    Product xFrance2022-040 1600
    Product xFrance2022-050 1700
    Product xFrance2022-060 1800
    Product xGermany2021-030 300
    Product xGermany2021-040 400
    Product xGermany2021-050 500
    Product xGermany2021-060 600
    Product xGermany2021-070 700
    Product xGermany2021-080 800
    Product xGermany2021-090 900
    Product xGermany2021-100 1000
    Product xGermany2021-110 1100
    Product xGermany2021-120 1200
    Product yFrance2020-07902019-011 1
    Product yFrance2020-08682019-012 2
    Product yFrance2020-0952019-013 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 🙂
  • Piyush_Ghungrud's avatar
    Piyush_Ghungrud
    Icon for Helper I rankHelper I
    3 years ago

    Remaining Data : 

     

    Product yFrance2020-10742019-014 4
    Product yFrance2020-11742019-015 5
    Product yFrance2020-12272019-016 6
    Product xFrance2021-0182021-011 1
    Product xFrance2021-0252021-012 2
    Product xFrance2021-03962021-013 3
    Product xFrance2021-04982021-014 4
    Product xFrance2021-05922021-015 5
    Product xFrance2021-06422021-016 6
    Product xFrance2021-07522021-017 7
    Product xFrance2021-08162021-018 8
    Product xFrance2021-09482021-019 9
    Product xFrance2021-10212021-0110 10
    Product xFrance2021-11952021-0111 11
    Product xFrance2021-1292021-0112 12
    Product xFrance2022-0122021-0113 13
    Product xFrance2022-02812021-0114 14
    Product xFrance2022-03402021-0115 15
    Product xFrance2022-04222021-0116 16
    Product xFrance2022-05642021-0117 17
    Product xFrance2022-06882021-0118 18
    Product xGermany2021-03612021-033 3
    Product xGermany2021-04492021-034 4
    Product xGermany2021-05682021-035 5
    Product xGermany2021-06202021-036 6
    Product xGermany2021-0712021-037 7
    Product xGermany2021-08192021-038 8
    Product xGermany2021-09372021-039 9
    Product xGermany2021-10552021-0310 10
    Product xGermany2021-11872021-0311 11
    Product xGermany2021-12792021-0312 12
    Product xGermany2022-01332021-0313 13
    Product xGermany2022-02602021-0314 14
    Product xGermany2022-03122021-0315 15
    Product xGermany2022-04942021-0316 16
    Product xGermany2022-05822021-0317 17
    Product xGermany2022-06732021-0318 18
    Product zFrance2021-04902021-041 1
    Product zFrance2021-0592021-042 2
    Product zFrance2021-06222021-043 3
    Product zFrance2021-07382021-044 4
    Product zFrance2021-08422021-045 5
    Product zFrance2021-09722021-046 6
    Product zFrance2021-10832021-047 7
    Product zFrance2021-11712021-048 8
    Product zFrance2021-12382021-049 9
    Product zFrance2022-01692021-0410 10
    Product zFrance2022-02742021-0411 11
    Product zFrance2022-03912021-0412 12
    Product zFrance2022-04542021-0413 13
    Product zFrance2022-05792021-0414 14
    Product zFrance2022-06452021-0415 15
    Product zGermany2021-04252021-041 1
    Product zGermany2021-05612021-042 2

    Thank you 🙂