Optimizing SUMMARIZE by using ADDCOLUMNS - Unplugged #40

Показать описание

Learn why you should use ADDCOLUMNS in DAX to compute aggregations instead of doing that inside SUMMARIZE: performance can be very different!

#unplugged

SQLBI

Рекомендации по теме

Комментарии

What a master class! Thanks Alberto for sharing those tips and tricks. And your way of reasoning. Very valuable :)

Anthony_Lecoq

Your videos are a wealth of information, it's like unlocking DAX superpowers! Thanks for your efforts, keep it up please.

kot

Best ever cooking show!
I just try to absorb and repeat way of thinking
Thank you, Alberto!

tARasKoni

I love the method of comparing your [Test] measure to the original measure to ensure that the expected result is still obtained. I already wrap my SUMMARIZE() in ADDCOLUMNS(), but this was a wonderful tip to learn!

christopherhaas

Read that article just a couple of days before, now I am super saiyan🔥🔥🔥

sane

it was amazing to watch how do you analyze a problem and solved it. Please make more videos like this one

Yo-pxxw

I like part Test to return zero to check optimisation. As always, simple and great video. Thank you!

sarajvo

Another great video that takes the complex and makes it seem simple and understandable. Thanks Alberto!

JohnSullivan

Great video, thanks a lot Alberto!! I had a similar issue and now the performance is so much better and faster.

gezin_longuevilleosaer

Ciao Alberto,
Thank you for this class.
I really appreciate it.
Thiago Pacifico

thiagopacifico

Amazing. Thanks for the class. Cheers.

viniciusfernandes

Thanks to help us to improve with each video.

johansantacruz

Best explanation as always! Keep up the good work 👍

egorshiyanov

What a convincing example! Thanks for the video! :)

wmfexcel

Great video Alberto! I believe it will be very appreciated if you would consider to make more videos with popular incorrect functions usage and obvious (for you, not us!) solutions. I nominate FILTER function as a next example.

kamilkalecinski

I’d like to see more debugging videos! Nice job!

rdg

Wow! Impressive course to learn how to optimize a measure 👏👏👏 But I don't understand with you embedded DISTINCTCOUNT inside CALCULATE (and only one argument in calculate)

FredericLEGUEN-Excel

Like the use of subtracting test measure from original measure to validate results.

sue_bayes

Awesome video. Thank you for the knowledge share. One unrelated question. What keyboard do you use? lol

aaronrodriguez

I'm new to DAX, sorry if question is not valid ☺️.

Piece

Optimizing SUMMARIZE by using ADDCOLUMNS - Unplugged #40

Optimizing SUMMARIZE by using ADDCOLUMNS - Unplugged #40

ADDCOLUMNS - DAX Guide

Addcolumns with Summarize function in Power BI - 15 (Power BI Training)

SUMMARIZECOLUMNS - DAX Guide

SUMMARIZE - DAX Guide

Summarize() vs AddColumns() vs SummarizeColumns() Which of these has the best performance & how ...

Combining Table Functions To Optimize Formulas In Power BI - DAX Technique

DAX Summarization Tricks in Power BI

How to use SELECTCOLUMNS and ADDCOLUMNS to generate new tables in Power BI // Beginners Guide

Using SUMMARIZE & ADDCOLUMNS to Group Columns in Power BI

How to SUMMARIZE with Filter/Condition using Dax in PowerBI | MiTutorials

How to Use ADDCOLUMNS in DAX

DAX ADDCOLUMNS [DAX Virtual Table Series - Ep. 2]

Comprehensive DAX Table Functions Tutorial (GENERATE, SUMMARIZE, ADDCOLUMNS, NATURALINNERJOIN +more)

SUMMARIZE [DAX Virtual Table Series - Ep. 5]

SUMMARIZE [DAX Virtual Table Series - Ep. 5]

DAX Fridays! #71: Optimize a DAX measure

Power BI ADDCOLUMNS function

DAX ADDCOLUMNS [DAX Virtual Table Series - Ep. 2]

How to use AddColumns function in DAX and Power BI

Optimizing callbacks in a SUMX iterator

DAX Fridays! #69: How to write a DAX measure (Part 1)

summarize vs summarizecolumns in dax | power bi dax tutorial

SUMMARIZECOLUMNS [DAX Virtual Table Series - Ep. 6]