PP06: Time intelligence Functions “PART I” Year on year change (CALCULATE-SAMEPERIODLASTYEAR-DIVIDE)

[@echxanh2003]

Thank you so much! I subscribed immediately after watching this video. It helps me so much!

[@azwarmzafar]

Thank you so much.

[@kevinshoemaker1466]

Your videos are awesome. I will be viewing all your videos. I've subscribed.

[@nASi007kHaN]

very well explained - Thank you

[@chandravindran]

Wonderful! I have been looking for this sort of video. Thanking you so much

[@AAAExcel]

thank you, happy that you like it

[@XLnCADMalayalam]

Awesome!

[@AAAExcel]

Thank you 🙏

[@z.719]

This is awesome! Very useful

[@AAAExcel]

Thank you so much 😊

[@Dom0909]

very helpful brother, thankyou

[@AAAExcel]

Happy that you found it helpful 👍

[@kishorpanara4191]

Awesome useful video thanks dear

[@AAAExcel]

Most welcome 🙏

[@kebincui]

thanks brother 👍

[@AAAExcel]

Most welcome 🙏

[@teoxengineer]

Excatly very good video. I'm waiting for such a type of tutorials and follow you.
I kindly want you to prepare about Cube functions with dropdown selections. Could you plase do it?
Thank you

[@AAAExcel]

Thank you so much for your comment, yes cube functions will come later in this series

[@mufycw]

why you used number in condition formatting rule? You could have kept Type as percentage and put the same value isnt it?

[@AAAExcel]

the type I changed is not the data type, it is the "threshold type", I did so as i wanted to enter absolute threshold

[@vagaming8064]

if product price changes every month then how we make its Dim table ?

[@AAAExcel]

You have to add a date column in the price list and to combine it with the product id column, obviously you need to do the same in the transaction table, then create the relation based on Date-ProductId column

[@mufycw]

why have you used 1- in calculating revenue by multiplying qty*1-discount*price?

[@AAAExcel]

If I give you discount of 10% this means that you are going to pay me 90%
Which is simply 1-discount %

[@mufycw]

@@AAAExcel Thank you so much for answering all my questions. Do you have power BI learning videos in English?

[@mohamedshousha2937]

لو سمحت هو الكورس ده متوفر بالعربي

[@AAAExcel]

يا نهار ابيض 😀
السلسلة كاملة موجودة بالعربي من مدة
th-cam.com/play/PL5NlUYOM2iOgpYyGRs-m33ifHRwbB8MTV.html

[@mohamedshousha2937]

@@AAAExcel تمام متشكر جدا مجهود رائع لدي سؤال لو سمحت أنا بادىء لسه في مجال تحليل البيانات وبتعلم اكسل هل اكمل في كورس الاكسل الأول وبعد كده اشوف السلسلة دي ولا عادي ابدء بها مع الاكسل

[@AAAExcel]

لو جديد في الاكسل لازم تتعلم شوية معادلات الاول وبيڤوت تابيل وبعد كده باور كويري وبعدين السلسلة دي

[@mohamedshousha2937]

@@AAAExcel تمام شكرا لحضرتك

[@AAAExcel]

انا عندي سلسلتين عن البيڤوت تابيل والباور كويري

[@entendedorww]

👍👍👍🦸

[@AAAExcel]

😍😍

[@carzetonao]

I hope I can understand Arabic

[@AAAExcel]

Did you subscribe to my English dedicated channle?
youtube.com/@aaaexcelenglish

[@carzetonao]

@@AAAExcel thanks for sharing

[@gowrisankarrao6529]

d it

[@AAAExcel]

👍