Nice explaination along with the dataset, this is what I was looking for. Thanks Bro.
@LearnDAX5 ай бұрын
I'm Glad that you were able to get some value out of this Video! Happy Learning Bro 😊
@monubhaiya90225 ай бұрын
Thanks sir much needed
@LearnDAX5 ай бұрын
Thank You 😊
@rajatsehgal42495 ай бұрын
While calculating Avg quantity sold you have used AVERAGEX , so can we use AVERAGE function also.
@LearnDAX5 ай бұрын
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 😊
@sourabhpatel38345 ай бұрын
Voice is low
@LearnDAX5 ай бұрын
Thank You! I will keep this in mind during future recordings 😊
@rajatsehgal42495 ай бұрын
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.
@LearnDAX5 ай бұрын
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!
@rajatsehgal42495 ай бұрын
@@LearnDAX First of all thank you very much for your reply. Nobody replies like this and clear the doubts as you are doing.
@rajatsehgal42495 ай бұрын
@@LearnDAXTotal Sales is a measure that I have used, that's why it can't be connected with Orders table(date).
@LearnDAX5 ай бұрын
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 😊
@rajatsehgal42495 ай бұрын
@@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.