Жыл бұрын
Жыл бұрын
Пікірлер
@krishnaRaog21 3 күн бұрын
Super ....Great job ...👍
@Data.Analytics.Central 3 күн бұрын
Thanks for the appreciation! 🤝
@M7amadhaifa 3 күн бұрын
how do we create the rfm chart if we have the value all sorted out
@marcelporcescu4675 4 күн бұрын
But how can we do daily. I tried but it show only 16 variable maximum, but we have 30 days
@brandonvarela133 4 күн бұрын
Okay so far so good? how do you use this data to create a parameter in the direct query?
@rajeevgosavi4514 4 күн бұрын
Great Technique Sir, Kindly share practice file used in here to follow along. Thanks Again.
@adityavedam1174 9 күн бұрын
Could you share the data file for Practice please ?
@spongebobby188 21 күн бұрын
@Data.Analytics.Central Can this method be used for data that isn't sales? So example, number of patients seen by a hospital over time?
@steponaszonys8385 Ай бұрын
Good examples, thanks. But what about HAVING ?
@Data.Analytics.Central Ай бұрын
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
@KamZardouzian Ай бұрын
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.
@user-ri7sw2wt6f Ай бұрын
Very helpful. However, PBI only imported the first 25 movies. Not sure why. BTW, I have the latest (May 2024) Power BI version.
@Data.Analytics.Central Ай бұрын
Thanks a lot for the appreciation!
@JuanHernandez-pf6yg Ай бұрын
Useful. Thank you.
@Data.Analytics.Central Ай бұрын
Thanks a lot for the appreciation!
@tinaflemons263 Ай бұрын
You have a DAX formula for Active customers. Does that mean I need to filter out Inactive customers?
@Data.Analytics.Central Ай бұрын
No, the Dax formula has priority.
@felixkitheka1686 Ай бұрын
You started the formula half way I did get where the value came from
@PhongMike 2 ай бұрын
Wonderful tips.. thank you very much..
@Data.Analytics.Central 2 ай бұрын
Thanks a lot for the appreciation!
@emilytran84 2 ай бұрын
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.
@emilytran84 Ай бұрын
Hello, I look forward to hearing from you :)
@user-cb1sc7se8g 2 ай бұрын
If I have to do the same thing but on a day level How can I achieved that?
@EkundayoOnifade 2 ай бұрын
Thanks for the video was very useful.
@Data.Analytics.Central 2 ай бұрын
Thanks a lot for the appreciation! 🤝
@arnoldnjogu 2 ай бұрын
Thanks, was driving me nuts!
@Data.Analytics.Central 2 ай бұрын
Thanks a lot for the appreciation! 🤝
@caseykirkup 2 ай бұрын
Amazing
@Data.Analytics.Central 2 ай бұрын
Thanks a lot for the appreciation! ❤️
@kimcook8640 2 ай бұрын
This is amazing. Thank you for sharing this video.
@Data.Analytics.Central 2 ай бұрын
I am glad that it helped you! 🤝
@mariusalexandrugogorita 2 ай бұрын
Best video ever! Thank you very much!
@Data.Analytics.Central 2 ай бұрын
Thanks a lot for the appreciation! 🤝
@user-dh6wx3fe6y 2 ай бұрын
Your M score formula is just the same as F score formula 6:16
@KamZardouzian Ай бұрын
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.
@bharathau8085 2 ай бұрын
Thank you, I was looking for his. It is so helpful.
@Data.Analytics.Central 2 ай бұрын
Glad it was helpful!
@chrismackenzie92 2 ай бұрын
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
@Data.Analytics.Central 2 ай бұрын
Thanks a lor for the feedback!
@hitendradagra7297 2 ай бұрын
Very Nice Workaround thought using fill down
@Data.Analytics.Central 2 ай бұрын
Thanks a lot for the feedback! 🤝
@Tiramisu2024 3 ай бұрын
The best lecture, Thank you so much!
@Data.Analytics.Central 2 ай бұрын
Thanks a lot the kind feedback!
@colevanwonderen3703 3 ай бұрын
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))))
@Data.Analytics.Central 2 ай бұрын
Thanks a lot for your elegant solution!
@777tmack 3 ай бұрын
This is exactly the solution I was looking for. I've liked and subscribed, looking forward to learning more from your valuable video tutorials.
@Data.Analytics.Central 2 ай бұрын
Awesome, thank you!
@Data.Analytics.Central 2 ай бұрын
Glad to be of help!
@janinesmith6638 3 ай бұрын
Hey, great video. Nicely explained. Thank you!!!🤓
@ahuhokay 3 ай бұрын
u are the best bro thank you for the help🙏
@Data.Analytics.Central 2 ай бұрын
Thanks a lot the kind feedback!
@FooMengNg 3 ай бұрын
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?
@FooMengNg 3 ай бұрын
Hope you can advise thank you!
@calvineng7958 3 ай бұрын
good stuff
@sureshnetala1032 3 ай бұрын
please provide sample file for practice
@rajudasari8482 4 ай бұрын
meaning of Granularity ??
@Data.Analytics.Central 4 ай бұрын
Granularity means at what level you analyze data for example: at year level, at month level, at day level?
@vijaymane34 4 ай бұрын
Disaponted. You didn't tell how to get trend (series) out from the time series.
@vijaymane34 4 ай бұрын
Intercept + time trend * period number (1 to n)
@Selo.K. 4 ай бұрын
Whats the solution of the dynamic page ?
@Data.Analytics.Central 4 ай бұрын
Please find here the solution: medium.com/bi3-technologies/loading-dynamic-web-data-in-power-bi-657b4324c42a
@parthsavla7283 4 ай бұрын
Link is not opening for the code
@Data.Analytics.Central 4 ай бұрын
Solved! docs.google.com/document/d/1HazRYR2g9D1sxjDLY1othxRm76N0DtOgfHoPWq04xcs/edit?usp=sharing
@user-yl1fo5wy6q 4 ай бұрын
Thank you
@Data.Analytics.Central 4 ай бұрын
I am glad that you have found it useful!
@davidnavas9065 4 ай бұрын
Thank You 😁
@Data.Analytics.Central 4 ай бұрын
I am glad that you have found it useful!🤝
@dariuxk2503 4 ай бұрын
Great tutorial. Could I have possibly stupid question please? How do I utilize this method for multiple items within single supplier?
@luthfizahiya5479 4 ай бұрын
bro thank you sm
@Data.Analytics.Central 4 ай бұрын
I am glad that you found it useful! 🤝
@savitribhattar2278 5 ай бұрын
In this, multiplicative method has been used then why trend has been computed using additive method. The equation used here is beta*((l(t)-l(t-1)) rather than beta*((l(t)/l(t-1)) Please suggest?
@savitribhattar2278 4 ай бұрын
ok may be this is Trend additive and seasonality multiplicative methods. Thanks Also one more question please, how to compute initial values of 12 and 13 months in excel?
@savitribhattar2278 4 ай бұрын
Or initial values of 4 quarters predictions in your example
@nazamulislamnazim303 5 ай бұрын
Thank you, Your video solved my problem, where I was stuck for almost the last 17 days. and I had to do it manually. love from Bangladesh.
@Data.Analytics.Central 5 ай бұрын
Hi Nazamul, I am happy that you have found it useful! 🤝
@roshandhumal1193 5 ай бұрын
Sir, could you please explain us why we have to lock 🔒 intercept, please explain and please explain me about p value.
@Data.Analytics.Central 5 ай бұрын
Hello, we lock the Intercept because in the equation the intercept is only one, while the coefficients are multiple. Please read here about the p value: www.investopedia.com/terms/p/p-value.asp
@muralidhar40 5 ай бұрын
Thanks for explaining the notion of dimensions, Through multiple examples you have made it clear.
@Data.Analytics.Central 5 ай бұрын
Thanks for the feedback! 🤝
@itamarconceicao6708 5 ай бұрын
Fantastic!!! Good job! Saved my life... I'm having problems with excel 2019 and power pivot. My Excel is 32bit and is complaining about lack of memory and this destroyed my connections and one of the queries was lost and I can no longer update or remove it to rebuild. Is there any trick for this? Let me ask you another question, but now about your tip... Is it possible to do the opposite way? Could you give an example like this? Thanks for sharing!!! Itamar C. São Paulo/BR
@jayintheweeds2629 5 ай бұрын
I accomplished something similar using a custom column with complex formula that slowed pq down so much. Your method was so much better! Thank you!
@Data.Analytics.Central 5 ай бұрын
Thanks for the feedback! 🤝
@paulpaul1623 5 ай бұрын
awesome. thanks!
@Data.Analytics.Central 5 ай бұрын
Thanks for the appreciation! 🤝
@roshandhumal1193 5 ай бұрын
Sir what If we have Jan to March instead of Jan to Dev Because of I have value from Jan to March and when I am doing the method the out is not showing right could you please give me a hint
@Data.Analytics.Central 2 ай бұрын
Hello, I hope you follow the rule: one variable less then the number of categories, so in your case of 3 months you use 2 variables
@hafizelbadawi5409 5 ай бұрын
I would like to thank you so much
@Data.Analytics.Central 5 ай бұрын
Hi, Hafiz. Thanks a lot for the feedback! 🤝