Expanded Table - The Whiteboard #04
HTML-код
- Опубликовано: 24 авг 2022
- What is an expanded table in DAX? Seeing it is better than a simple description!
Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: www.sqlbi.com/blog/marco/2022...
#thewhiteboard Наука
Great sharing of DAX critical concept! Thanks a million!
Marco - Thank you so much for starting these whiteboard tutorials. The experience is wonderful and not as jarring as switching screens continuously during a regular tutorial. Please keep this new set up as there is so many topics can benefit greatly from this new whiteboard approach.
good stuff
Marco, Alberto, i'm from Algeria. Thank you so much with your videos i came to the point to understand the key concepts of Dax:
-evaluation context
-calculate/calcuatetable
-iterators
-context transition
-expanded tabels
This is Amzing contents where i get most enhanced dax knowledge!! thank you marco!
Thank you so much for the incredible information you’ve shared with the world! I’ve learned so much from your videos.
Thank you so much for the insights in your videos. Using the great Dax Studio 3.0 was interesting to see the performance differences in the second example.
Red Sales =
CALCULATE (
[Sales Amount],
Product[Color] = "Red"
)
only took 1 SE Query.
Red Sales =
CALCULATE (
[Sales],
FILTER (
Sales,
RELATED ( Product[Color] ) = "Red"
)
took 3 SE Queries.
Truly grateful for the tools and videos to be able to develop understanding and do this type of analysis.
your performance test and conclusive point here is the icing on the cake (Marco's video)
Perfectly explained!!! Whitevoars ie great
One of the best expansions I’ve seen so far on the topic!!
Thank you for your work 👍
Looking forward to see the episode about relationships in DAX if there will be one!
Amazing, Marco!!!!!
The by far best way to learn all of this and much more is to read Marco's and Alberto's book: The Definitive Guide to DAX. There's no other book like this one. If somebody is serious about DAX, it's a must-read. Nothing's gonna give you more info on the language and its intricacies.
Muito bom !
Thank you for the video. I was just wondering, how is it possible to create more rows by following a 1-N relation (in the example provided the sales table "has all the rows")? Another thing, you have noted to always "filter columns not tables" - but the filter function (used in the examples) works only on tables.
i was wondering what is the most efficient way to write the "Red Sales" measure.
As Marco mentioned filter columns, not tables! So I think the best approach would be to write Product[Color] = “Red” as the filter argument in the CALCULATE expression, correct me if I’m wrong.
I wish someone could explain CACLULATE steps in such way. This is in a book but the explanation is really not so easy to understand. Understanding calculate is key concept but there are so many interpretation to these steps.
I dont think you use white board effectively because it is not understandable