Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Analyze dynamic ranking list with Cohort

  • 1.  Analyze dynamic ranking list with Cohort

    Posted 17 days ago
    Edited by ANDRE SOUZA 17 days ago
      |   view attached
    Step by step calculation demand
    1. Take the average value sold in the last 3 months by product
    2. Make a ranking of this value taking the 25 worst
    3. Create a monthly list of the 25 worst of each month and follow the evolution)
    4. Take this single value and plot it on the cohort showing the evolution of the list.
    5. A column with the Total and another with the quantity (Count)

    Example of how the result should look




    ------------------------------
    ANDRE SOUZA
    Analista de BI
    ITU
    ------------------------------

    Attachment(s)

    pbix
    Cohort Teste_V6.pbix   3.60 MB 1 version