cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
corvada Regular Visitor
Regular Visitor

Who can help me witt my Cohort Analysis?

Hi everyone,

 

Can someone help me with the following issue?

 

I have a report in PBI:

 

Sam-Cohort 1.JPG

 

and in Excel I have:

 

Sam-Cohort 2 Excel.JPG

 

I want to have the Excel-report also in PBI but I don't know what I have to do. I think I have to use a sort of supporting table:

 

Sam-Cohort 4 Goal.JPG

 

but I don't know how. Can someone help me?

 

Thanks in advance,

 

Cor

 

5 REPLIES 5
Community Support Team
Community Support Team

Re: Who can help me witt my Cohort Analysis?

hi, @corvada 
Yes, you could get it by "Sort by column in Power BI Desktop".

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
corvada Regular Visitor
Regular Visitor

Re: Who can help me with my Cohort Analysis?

Hi @v-lili6-msft ,

 

Thanks for your reply but can you tell me how I can do it?

 

Community Cohort.JPG

 

Best regards,

 

Cor

 

 

Community Support Team
Community Support Team

Re: Who can help me with my Cohort Analysis?

hi, @corvada 

It is sort by column function. refer to these articles:

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

4.JPG

http://radacad.com/sort-by-column-in-power-bi

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
corvada Regular Visitor
Regular Visitor

Re: Who can help me with my Cohort Analysis?

@v-lili6-msft: I know where I can find the sort of the columns but unfortunately it's not the solution. It isn't gving me the result I want. :-(

Community Support Team
Community Support Team

Re: Who can help me with my Cohort Analysis?

hi, @corvada 

I may have a misunderstanding on your case, Could you share your sample pbix file and your expected output.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.