How to use the Power BI Aggregations Feature

In this video, Adam sits down with Christian Wade to discuss how to use the Power BI Aggregations feature. This video will show you the clicks to get to the clicky clicky draggy droppy awesomeness when working with big data, or even massive data.

Christian Wade on Twitter - @_christianWade

LET'S CONNECT!

Guy in a Cube
-- Snapchat - guyinacube

***Gear***

[toulasantha]

Christian is flawless in explaining this. Love the energy.

[sivajan]

Christian Wade is one of my favourite Microsoft speakers! Absolutely love his enthusiasm for the product.

[MishkyGammy]

Thanks Adam/Christian, this video is worth every second of the time spent

[pawewrona]

This is the video from 2018... How can it have only 600 likes?! Super cool, really glad I found it.

[alexjunk]

Great video, Adam and Christian! I can't wait to give this a go. Keep it coming...

[guavaq]

Great video, and explanation on how it all works. As always a few nuggets of gold from Christian

[raviv]

Wonderful! It was amazing presentation. Just one question I have.


These aggregate tables are Duplicate Tables in PBI (Duplicate or Referenced)? Or they are directly fetched from source by firing aggregated query?

[metube]

Thanks a lot for this video
Really useful, i have question, is it possible to create multiple aggregate tables?

[eshagoradia]

can you please include a video on how to find max values across multiple columns the way we use in Excel - MAX(col1, col2, col3....)?

[DanielWeikert]

Thanks for sharing. I guess I need another "Guy in a Cube" Video where Aggregations and the different Modes are used on a real life example? Is that possible? ;)

[vinaykumarsingh]

Thanks for detailed description, I have a single table and visualization created in a report. Users want to export underlying data from this visualization!! How to do that I am not able to setup aggregate on it to accomplish pls help

[abhisoulstormer]

The video is a goldmine of information! Thanks as always :D

[luislopezacevedo]

Wonderful! Can I have multiple aggregation tables? Meaning: an agg table for a set of dimensions (product and store) and another for date? I'm doing a test but the more dimensions I add the bigger the agg table become, impacting the performance. Thanks :)

[hannesmayer]

It's good to see good old - and in many ways very useful - functionality from multidimensional models coming back to tabular model.
I am looking forward to it! It was missed for a long time for the obvious reasons.
About timelines ;-) soon will be this year? Is my assumption correct that it's coming at the same time in Azure Analysis Services?

[irzanti]

Great video. What's the minimum laptop configuration to run the data?

[clokeshreddy]

Great feature in power bi.
this will lift the power bi to the next level.
Can you also let us know if the same feature also added to Azure Analysis Services in the near future?

[selfservicebi]

Great feature.
Great Video.
Thanks guys!

[chrisi]

Brilliant! ... I want ask: Is the Aggregation Table should be populated with aggregated dat in the database before pulling it in to Power BI model. If yes, can I can create the aggregation table as View?

[NikoSuomiUlkoilee]

Wow, thank you a lot! This feature is now so clear to me :)

[josemadrid]

Is this feature coming to SSAS Tabular in the future?