First time watching your video. Extremely helpful. Literally searched for an hour to understand the purpose of group by
@HowtoPowerBI3 жыл бұрын
thx Chaitanya! happy to hear it helped.
@doaaismail18422 жыл бұрын
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 👍
@HowtoPowerBI2 жыл бұрын
Thanks Doaa! Super happy to see you think so :)
@mcdonaldikisielmeow Жыл бұрын
Respect you for "Polski" book behind you :)
@sebastiengagnon-bernier208610 ай бұрын
Thanks for your guide :) That's not like Excel but you are really clear! Thanks you bud
@JourneyofanEnthusiast4 ай бұрын
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?
@HowtoPowerBI4 ай бұрын
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
@totvabe14 жыл бұрын
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?
@HowtoPowerBI4 жыл бұрын
You then need to make sure that in the query editor you group by year and month.
@borysbuza47832 жыл бұрын
is that a polish language library n the background :) nice!
@HowtoPowerBI2 жыл бұрын
Haha can be- didn‘t you know im half polish? ;) milego dnia :)
@borysbuza47832 жыл бұрын
@@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?" :)
@HowtoPowerBI2 жыл бұрын
@@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 :)
@shivmantra14062 жыл бұрын
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.
@alicedwonderland77333 жыл бұрын
Very nice video - thank you!
@mohdmuzammil30593 жыл бұрын
New to your panel, found very useful
@HowtoPowerBI3 жыл бұрын
Glad it was helpful! thank you!
@kennethstephani6923 жыл бұрын
Excellent video!
@HowtoPowerBI3 жыл бұрын
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
@JohnJoe1319 ай бұрын
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?
@HowtoPowerBI9 ай бұрын
you can use Group by statement in a native query or create a view which you connect to in pbi
@rrrraaaacccc80 Жыл бұрын
👍💯
@Bruno20k.2 жыл бұрын
thanks
@HowtoPowerBI2 жыл бұрын
You are welcome :)
@dilshadsavinda1623Ай бұрын
Good tutorial. Small suggestion !!! We don't want to see half of your face on the screen in tutorial , its annoying. voiceover is enough.
@HowtoPowerBIАй бұрын
Thx there are plenty of channels with VO, im sure you can find one that suits you better