Power BI Practice Solution ROUND #6 I Analyze your data by COHORT

[@waqarshaikh86]

Thanks Bas, this is exactly what I was looking for. To the point and easy to understand.

[@Smeetr]

Hi Bas, Great explaination, one quick doubt
at 05:35 , cant the same column be achieved with this formula
YearOfFirstOrder = year(FIRSTDATE(Sales[Order Date]))

[@SunilMathewMusic]

I used it and it gives the same result. Then I guess we don't have to use RELATEDTABLE function here.

[@Gwenz9721]

Great one, thanks!!

[@oricchannel2811]

Another great video. Thank you for sharing !!!

[@irfanabbassi9202]

Really outstanding explanation...

[@pilarbaldominos2505]

Great video... I am just starting my power bi journey and all these "extra" explanations helped me a lot (ie: why I need the calculate to create the column)... Looking forward seeing next video!

[@HowtoPowerBI]

Glad it was helpful! next one coming up soon

[@abeerattia4523]

Very interesting and useful and insightful analysis, thanks

[@HowtoPowerBI]

Glad to hear this Abeer, thanks for watching

[@genevieve3676]

Hi Bas - For the last graph, I don't find the type of graph with value - I only have those with X and Y axis - is it possible to tell us which one we have to pick ? thanks

[@andrewgilmore3563]

Use Y-axis.

[@MacPaulos]

Hey Bas, nice video.
If you needed to avoid calculated columns, how would you approach this?

[@nikakalichava8012]

Thanks a lot!

[@excelbear6860]

enjoying all the practices, Bas.
for YearOfFirstOrder, why not just this?
YEAR(CALCULATE(MIN(Sales[Order Date])))
not sure why RELATED is not required. but it gives the same answers. or is this slower?

[@HowtoPowerBI]

😮that does look easier and more efficient! next time I need to run the solution by you first for a double check haha 😀 thanks for pointing out!

[@excelbear6860]

@@HowtoPowerBI haha you flatter me. I just think simple because I only know simple. I have another one for round 7 too.

[@SSM_33]

you just saved me bro thanx alot

[@barttitulaerexcelbart9400]

Well done Bas! When I was making your example I did not have this option categorical/continuous. Later I saw it in the options.

[@HowtoPowerBI]

Thx Bart! If the X-axis is string/Boolean, the Type option will not display. Maybe you initially had a different field on the x axis and therefore it didnt show.

[@stevedoherty6649]

I had no idea the new customer's pattern was now a quick measure. 👍

[@HowtoPowerBI]

yea, easy to overlook that one! :D

[@lijunchen]

Thanks, Bas. This video is great and very informative. But I have a question about the 2nd chart: total sales by Year, with breakdown legend of Year of First Order. I wonder instead of using Year of 1st Order, can you use Customer Age/Tenure as the breakdown legend? This will be dynamic according to the Year / Timeline, so for the customers with 1st orders in 2015, their tenure will be 0, 1, 2, 3 respectively in 2015 to 2018. I think using customer tenure / age group as the legend has many uses, like checking the views of your new and old subscribers across time. I have tried but failed to create such a legend. I wonder whether you have some ideas?

[@SRaturi89]

Very Informative, Thanks Bas!

[@HowtoPowerBI]

great to hear! thx😀

[@cescodeidda277]

Where is the dataset ?

[@HowtoPowerBI]

download link is in the description

[@laiqmehdi8704]

i love u ar exercises please we need more

[@alisheryuldashev9857]

Hi! It was awesome, but could you please make “classic” cohort analysis using matrix. I still can’t find any normal solution (((