Working as Head of Business Controlling for the worldwide leader in Fashion Retail (30 Billion EUR turnover), I am constantly upgrading my Data Analytics skills.
My focus is on Modern Excel (Power Query and Power Pivot), Power BI and DAX.
This channel's mission is to share useful insights about working with data.
как вы считаете churn rate если вы не знаете кто из тех кто купил в прошлом месяце купил в этом?? DiffCust - это просто разница между количеством покупателей, которая может сказать лишь о том, стало ли покупателей больше в текущем месяце или нет
Thanks for the appreciation. For your question, you have here the answer: community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Equivalent-of-HAVING-in-DAX/td-p/3691717
Hi, thanks for the video. Very helpful. The M Score formula should have [M Value} instead of [F Value]. I think this is causing a lot of the issues other people are having.
Thank you for your great video! Do you think this work correctly with 12 months data historical and some month value = 0 as well ? I look forward to hearing your advices. Then how can we apply for multi sku products.
Yeah, I caught that too. The M Score formula should have [M Value} instead of [F Value]. I think this is causing a lot of the issues other people are having.
Made more sense to me when I realized you had two different y axis. If you do this again, better to show them on the same y axis. Awesome info otherwise! Thanks
This was a good solution. I also found that you can modify this query to collect the 2nd value if say the values were in varying columns "Step Name" = Table.AddColumn(#"Add Name Column", "Value", each List.First((List.RemoveFirstN(List.RemoveNulls(Record.ToList(_)),2))))
Hey man, I used the data and the given DAX code, I ended getting all the RFM = 555 why is that so in the RFM Table? is there something wrong with the DaX code?