Much appreciated. I’m running into an issue where the sequence of the market basket is not always the same despite containing the same products. For example 243-345 vs 345-243. I tried to add a sort step on Product ID in power query but does not seem to remedy the DAX Logic. Any thoughts on how to output a consistent market basket sequence would be appreciated.
Very smart solution, really enjoy to see how you mixed several concept together in a simple way. Waiting por second part. Congratulations, amazing video!!!
Thanks in a million. Great content. Awesome. Very well explained. I couldn't find this explanation--simply put anywhere else. Great teachers are hard to find. Grade: A++💥
Eu já assisti a mil vídeos sobre este tema. E todos são muito, mas muito complexos. Da até vontade de desistir de tentar. Mas vem você com uma explicação TÃO SIMPLES que fiquei até com medo e pensei: "meu Deus! Não é possível ser tão simples. Não pode funcionar!!!"" hahahaha..mas PARABÉNS!!! FANSTÁSTICO!
@@KnowledgeBankPro In english: He saw a thousand videos about that topic and they were very complex, almost makes he give up. But you came with a so simple explanation and made he feels so scared and think something like "oh my God, there's no way this works, it's so easy! hahahaha, but congrats bro, fantastic, awesome! hahaha
Hi, thank you for making this video and sharing the report. I have a question regarding the Sales & Magin % by Product. How I can make the scatter chart to change based on the Product code selection on the column chart? my report not changing when I select the product code.
Hi can you tell me whats the formula to create Transaction ID? I just have 4 coloumns (ID, PartID, Date, Qty). I just realized that there is a customer that buy different Part ID in the same date. I want to create Transaction ID Coloumn.
@@ed2921 Just remove calculate and use your filtered table as the first argument in concatenatex and it will give the same result. CONCATENATEX( FILTER( ALL(Sales), Sales[Transaction ID] = EARLIER(Sales[Transaction ID]) ), Sales[Product ID], "-" )
Even I'm thinking the same ... How 2nd row's Market basket is concatenated ... Because it's earlier value is 1 which is not equal then how it's concatenated??
![Market Basket Analysis [Association Analysis]](/img/n.gif)
Much appreciated. I’m running into an issue where the sequence of the market basket is not always the same despite containing the same products. For example 243-345 vs 345-243. I tried to add a sort step on Product ID in power query but does not seem to remedy the DAX Logic. Any thoughts on how to output a consistent market basket sequence would be appreciated.
Very smart solution, really enjoy to see how you mixed several concept together in a simple way. Waiting por second part. Congratulations, amazing video!!!
Thanks in a million. Great content. Awesome. Very well explained. I couldn't find this explanation--simply put anywhere else. Great teachers are hard to find. Grade: A++💥
How 2nd row's Market basket is concatenated ... Because it's earlier value is 1 which is not equal then how it's concatenated???
This is great. With DAX in Power Pivot, some of these analyses work in Excel as well
Looks awazing.can you please tell how you calculated total sales on market basket table.
Create a measure of sum(sales) within your sales table and then use that measure in your Market Basket Analysis table.
Eu já assisti a mil vídeos sobre este tema. E todos são muito, mas muito complexos. Da até vontade de desistir de tentar. Mas vem você com uma explicação TÃO SIMPLES que fiquei até com medo e pensei: "meu Deus! Não é possível ser tão simples. Não pode funcionar!!!"" hahahaha..mas PARABÉNS!!! FANSTÁSTICO!
can't really understand what you are saying :) but i hope you found it to be useful!
@@KnowledgeBankPro In english: He saw a thousand videos about that topic and they were very complex, almost makes he give up. But you came with a so simple explanation and made he feels so scared and think something like "oh my God, there's no way this works, it's so easy! hahahaha, but congrats bro, fantastic, awesome! hahaha
Great and simple, thank you!
You're welcome!
Hi, thank you for making this video and sharing the report. I have a question regarding the Sales & Magin % by Product. How I can make the scatter chart to change based on the Product code selection on the column chart? my report not changing when I select the product code.
Awesome video... what time frame do you typically use for this analysis?
from 12 to 24 months or more... depends of what we are trying to do
thank you very much for this video! It was really useful
Perfect. Love it
thanks I was just needing it .
you are very welcome!
How 2nd row's Market basket is concatenated ... Because it's earlier value is 1 which is not equal then how it's concatenated???
Hi can you tell me whats the formula to create Transaction ID? I just have 4 coloumns (ID, PartID, Date, Qty). I just realized that there is a customer that buy different Part ID in the same date. I want to create Transaction ID Coloumn.
You can create a index column in Power Query.
Clever!
ty!
very helpful. thankyou
I’m a bit surprised by the CALCULATE in the calculated column Marktet Basket. I believe it is unnecessary.
Hmm, can’t think of another way to do it without Calculate Jan. Otherwise no row context and you’ll get same basket all the way down.
@@ed2921 Just remove calculate and use your filtered table as the first argument in concatenatex and it will give the same result.
CONCATENATEX(
FILTER(
ALL(Sales),
Sales[Transaction ID] = EARLIER(Sales[Transaction ID])
),
Sales[Product ID],
"-"
)
Nice
How 2nd row's Market basket is concatenated ... Because it's earlier value is 1 which is not equal then how it's concatenated???
so basically this analysis cannot be done without order ID info in the dataset
How 2nd row's Market basket is concatenated ... Because it's earlier value is 1 which is not equal then how it's concatenated???
👍🏻
I'm here to say that these model is totally wrong. It doesn't separate when a ticket only has one product.
Even I'm thinking the same ... How 2nd row's Market basket is concatenated ... Because it's earlier value is 1 which is not equal then how it's concatenated??