Forum Discussion

qwaiti27231's avatar
qwaiti27231
Helper III
9 years ago

Cohorts reports

 

I need help to make cohort reports in the powerbi...and plus i have to merge the database from 2 db. where they have similar columms such as order No and user id  but it has different value. and merge the data from these two and make it a cohort report..if u can help me with step by step..it would be great help..

Need Help

7 Replies

  • Abduvali's avatar
    Abduvali
    Skilled Sharer
    9 years ago

    Hi qwaiti27231,

     

    You don't need to merge 2 DB's if they contain same unique Order No, you can just create a relationship by linking them say like:

    Order No from Orders table to Order No from Sales table see link below for more details:

    so try loading two tables, link them based on their Order No and start building your report and if you will require any additional help feel free to contact.

     

     

    Hope it helps

     

    Regards

    Abduvali

     

      • Abduvali's avatar
        Abduvali
        Skilled Sharer
        9 years ago

        You can you conditional formatting for that:

         

        Or you can you use some custom visuals to display your data maybe Heat Table visual might work for you.