Goodly is the best one!!!! Thank you 🙏 implicit calculations and transactions are the dark side of the DAX. It requires to pay attention as we do it for contexts. I'll always mark every your trips and explanations. Keep this position for beginners like me
Hi Chandeep. Excellent advice. Implicit calculations are fine for simple quick analysis. But, explicit calculations are the best place to spend your time learning, as you can do so much more and with so much more control. Thanks for the great tips :)) Thumbs up!!
Hi Chandeep, thanks for the wonderful content. I have a requirement where I need to create an amount slicer and whenever I change the year filter the amount value (for instance if I click on 2022 the slicer amount between 0 - 10M in a particular year should display in the slicer) should dynamically change accordingly. Is there a possibility to create such a slicer ?
You earn one subscriber cos your explanations is simple & clear enough unlike others I have watched today 😂 I am a bit confused why you don’t want to include multiple order date since it’s an order on the same day. Don’t you think that will give us more accurate sales per day say for instance some different persons order black bag different time per day that should be the sun of blacks bag divided by the total number of orders per day right? I am a bit confused tho thanks for for readily responding and shedding more light
I legit understood implicit & explicit measures cos you nailed it But still confuse as to how we can get the average sales per day if we didn’t include all the dates for the daily order????
Can i hv a face to face interactive online class....? Actually i hv so many doubts that can b cleared by face to face interaction....could u pls tell me the FEE?
Goodly is the best one!!!! Thank you 🙏 implicit calculations and transactions are the dark side of the DAX. It requires to pay attention as we do it for contexts. I'll always mark every your trips and explanations. Keep this position for beginners like me
Finished watching
Hi Chandeep. Excellent advice. Implicit calculations are fine for simple quick analysis. But, explicit calculations are the best place to spend your time learning, as you can do so much more and with so much more control. Thanks for the great tips :)) Thumbs up!!
Yes, exactly!
Thanks so much for this wonderful video! That is exactly what I want to understand explicit/implicit measures.
Good info....
Hi Chandeep, thanks for the wonderful content. I have a requirement where I need to create an amount slicer and whenever I change the year filter the amount value (for instance if I click on 2022 the slicer amount between 0 - 10M in a particular year should display in the slicer) should dynamically change accordingly. Is there a possibility to create such a slicer ?
Thank you 🙏🏼
Goodly is very good
Is there an explicit Standard Deviation calculation in DAX? Similar to Calculate(Stdv.sx)
You earn one subscriber cos your explanations is simple & clear enough unlike others I have watched today 😂
I am a bit confused why you don’t want to include multiple order date since it’s an order on the same day. Don’t you think that will give us more accurate sales per day say for instance some different persons order black bag different time per day that should be the sun of blacks bag divided by the total number of orders per day right? I am a bit confused tho thanks for for readily responding and shedding more light
I legit understood implicit & explicit measures cos you nailed it
But still confuse as to how we can get the average sales per day if we didn’t include all the dates for the daily order????
thank you
One more thing. When accessing the Power BI dataset through Power Query in Excel, only measures can be used as values.
Any discount for the course?
Hi Chandeep
This is right or wrong
Averages Per Day = divide(
[Total Sales],
DistinctCount(sales(orderdate)
)
The measure is conceptually correct. The bracket placement is incorrect
How about including the table before the [Total Sales]? Can’t that also give an error?
😊😊😊
Can i hv a face to face interactive online class....? Actually i hv so many doubts that can b cleared by face to face interaction....could u pls tell me the FEE?
I am planning on doing a face to face session for DAX and Power Query. Please watch for the announcement on RUclips soon.
Thanks