GROUP BY in Power BI Query Editor - Do you need all that detail?

No video

GROUP BY in Power BI Query Editor - Do you need all that detail?

Рет қаралды 26,632

How to Power BI

Күн бұрын

Пікірлер: 28

@chaitanyagutta2800 3 жыл бұрын

First time watching your video. Extremely helpful. Literally searched for an hour to understand the purpose of group by

@HowtoPowerBI 3 жыл бұрын

thx Chaitanya! happy to hear it helped.

@doaaismail1842 2 жыл бұрын

Thank you very much Bas. You really made it simple to understand the reason why I need aggregate while I can do it in the visualization. Thumbs up for this wonderful illustration 👍

@HowtoPowerBI 2 жыл бұрын

Thanks Doaa! Super happy to see you think so :)

@mcdonaldikisielmeow Жыл бұрын

Respect you for "Polski" book behind you :)

@sebastiengagnon-bernier2086 10 ай бұрын

Thanks for your guide :) That's not like Excel but you are really clear! Thanks you bud

@JourneyofanEnthusiast 4 ай бұрын

Thank you! its very useful.. you explain it well. a small query. how to take the report by customer and year in the same report?

@HowtoPowerBI 4 ай бұрын

create a customer and date table in your model, link them to your fact table (eg sales).. then add the customer, year, sales fields to a visual

@totvabe1 4 жыл бұрын

Great video! A question … If I'm grouping by Year thinking in a yearly visualization, could I show in a different future visualization data per month? Or am I losing granularity?

@HowtoPowerBI 4 жыл бұрын

You then need to make sure that in the query editor you group by year and month.

@borysbuza4783 2 жыл бұрын

is that a polish language library n the background :) nice!

@HowtoPowerBI 2 жыл бұрын

Haha can be- didn‘t you know im half polish? ;) milego dnia :)

@borysbuza4783 2 жыл бұрын

@@HowtoPowerBI had no idea, that is so cool! Sitting at my office desk I have a view on rondo jazdy polskiej, and when I saw the books I was like "am I trippin from the heat and mixing up realities?" :)

@HowtoPowerBI 2 жыл бұрын

@@borysbuza4783 hahah no, kidding, not by birth but mentally yes, I also visit my family there often, and this video was recorded in poland :):) youtube cant wait :)

@shivmantra1406 2 жыл бұрын

Hey Bas, I have been following u since I picked up PowerBI and your awesome. Have a question. I have a dashboard view tabs for daily, monthly, yearly views of IT tickets. Do you recommend duplicating the fact table into daily, monthly, yearly tables and grouping the data as per the ticket created date? Note that the created date is a date+time value.

@alicedwonderland7733 3 жыл бұрын

Very nice video - thank you!

@mohdmuzammil3059 3 жыл бұрын

New to your panel, found very useful

@HowtoPowerBI 3 жыл бұрын

Glad it was helpful! thank you!

@kennethstephani692 3 жыл бұрын

Excellent video!

@HowtoPowerBI 3 жыл бұрын

Thank you!!!

@MarcBartsoen Жыл бұрын

Hi Bas, Working on the built of a (to my standards) complex financial model holding different FactTables with the same number and type of columns. I can not append these, while getting an error code when being refreshed (timed out). In order to find a way to "get' my values from YTD to month numbers, I - as a first step - decided to apply your "Group By" to all the FactTables, which takes a while to "process", but somehow simplifies the tables as such (also taking into account one of your observations that this would benefit the performance of the BI dashboard). Next step was to create a measure that would collect all the amounts in the different FactTables. Unfortunatley, this results in different values between the original FactTable and the created measure. Any idea of this 'Group By' could indeed cause these differences ? Thx in advance, M

@JohnJoe131 9 ай бұрын

I use Dynamics 365 as the data source, and each time I use the group by it absolutely cripples my file and take over an hour to load. Is Group by just highly inefficient?

@HowtoPowerBI 9 ай бұрын

you can use Group by statement in a native query or create a view which you connect to in pbi