Who can help me witt my Cohort Analysis?

[Anonymous]

Hi everyone,

Can someone help me with the following issue?

I have a report in PBI:

and in Excel I have:

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:

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

Thanks in advance,

Cor

[v-lili6-msft]

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

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft ,

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

Best regards,

Cor

[v-lili6-msft]

hi, @Anonymous 

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

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

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

Best Regards,

Lin

[Anonymous]

@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. 😞

[v-lili6-msft]

hi, @Anonymous 

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

Best Regards,

Lin