Mastering DAX: Learning DAX through Scenario Based Questions Part 1

[@meeradhumne4685]

Very informative and helpful video

[@LearnDAX]

Thank You 😊

[@deepakbhandari9354]

Excellent

[@LearnDAX]

Thank You 😊

[@deepakbhandari9354]

Superb

[@LearnDAX]

Thank You 😊

[@DeveshSingh-jm4tl]

Nice explaination along with the dataset, this is what I was looking for. Thanks Bro.

[@LearnDAX]

I'm Glad that you were able to get some value out of this Video! Happy Learning Bro 😊

[@monubhaiya9022]

Thanks sir much needed

[@LearnDAX]

Thank You 😊

[@rajatsehgal4249]

While calculating Avg quantity sold you have used AVERAGEX , so can we use AVERAGE function also.

[@LearnDAX]

Yes, we can use either of the two functions! In case you want to know more about which function can be used in which case, I have created a Video on the same! Hope that helps 😊

[@sourabhpatel3834]

Voice is low

[@LearnDAX]

Thank You! I will keep this in mind during future recordings 😊

[@rajatsehgal4249]

I'm using Previous Month DAX function - Previous Month Sales= CALCULATE([Total Sales],PREVIOUSMONTH(orders[date]). I haven't use sum function in Calculate because I have used Total Sales measures. for that. But when I insert it in the table visual it does not show any value.

[@LearnDAX]

I think the reason why you might be seeing a blank value could be because the dates that you are sourcing from which is the Orders table may not have an active connection with the Sales table. Please check if there is relationship established between the date table you are using for the PreviousMonth function which is Orders as you have mentioned and the Sales Table. Hope that Helps!

[@rajatsehgal4249]

@@LearnDAX First of all thank you very much for your reply. Nobody replies like this and clear the doubts as you are doing.

[@rajatsehgal4249]

@@LearnDAXTotal Sales is a measure that I have used, that's why it can't be connected with Orders table(date).

[@LearnDAX]

Thank You for your Kind Words ! Appreciate that a Lot! Will try to help as much as I can 😀 Total Sales is a Measure which you may have created using the Sales table so you will have to connect the Sales Table with the Date table and the PreviousMonth function will work fine! Hope this would give you the correct solution 😊

[@rajatsehgal4249]

@@LearnDAX There is Order_details table in which I'm having sales column and I have connected the Orders table with Date table via column column i.e Order ID.

[@deepakbhandari9354]

Excellent

[@LearnDAX]

Thank You 😊