These are so helpful I know I'm going to need to revisit some so here's the content shortcuts Power Query: ============ 0:28 See the row 1:07 Find the Column (Ctrl+G) 1:40 FIlter by select rClick DAX === 2:15 Visual line break 3:25 Filter from the fact table (Calc + Table) 5:40 Maxx for Max of 3 measures Visuals ======= 8:04 Padding 9:00 Resizing columns using Shift + arrows 9:45 Lock objects
Nice tips overall! I feel embarrassed, but I have been struggling with reverse filtering in several cases and haven't been using a consistent method to bypass that limitation properly. So big thanks for DAX trick #2 and getting to understand the concept behind that.
That pseudo table part was great Chandeep.. Nice content as always! 🤟Loved it. The tip about the Lock Object had already been shared on some previous days' tips😁😁
Some pure nuggets there, thanks Chandeep!!! Just wish I could set column width similar to excel and choosing multiple columns to set width. I'm aware of the measure method with x 0's for example, but that doesn't seem to work if my matrix table consists of multiple measures to populate the values. 😢
The column resize trick is SO good!
Thanks :)
These are so helpful I know I'm going to need to revisit some so here's the content shortcuts
Power Query:
============
0:28 See the row
1:07 Find the Column (Ctrl+G)
1:40 FIlter by select rClick
DAX
===
2:15 Visual line break
3:25 Filter from the fact table (Calc + Table)
5:40 Maxx for Max of 3 measures
Visuals
=======
8:04 Padding
9:00 Resizing columns using Shift + arrows
9:45 Lock objects
That MAXX with the 3 measures and using default Value column was awesome!
reverse filtering and pseudo table trick was awesome,thanks man!
Reverse Filtering is awesome
The reverse filtering will be really helpful.!
Loved the last one for a pseudo table, don't think I've seen it before but looks really useful.
Helpful tip, Thanks
Wise advice and excellent improvements in the functionality of our work. Thank you!!
Sir, your videos are outstanding!!! Wish to have found your channel earlier in my Power BI journey. Best regards from Germany
Great tricks. Keep posting such tricks frequently ❤. Life gets easier with your tricks.
Sure, I will. :)
5:14
For better performance use Keepfilters(fact table) instead of just fact table
Weltklasse! Valuable DAX - and even See the row and Resize columns was awesome...
These tricks truly make life easier. Thanks.
great tricks - especially there expanded tables. I literally just used it today - had to go a few tries before I got it right :)
Well done!
Amazing. I absolutely love your channel.
Absolutely great!!. Thanks for sharing
nice tips man, thanks
DAX tricks are super awesome, thank you so much
Very good tips ! Many thanks !!
excellent tutorial brotha
You nailed it everything. Mindblowing!!
The first 2 Power query tricks were awesome
Thank you 😊
Simply superb
Dax no. 3 trick is awesome 👌... thanks 😊
There is always something new, amazing and useful in your videos. Thanks a lot!
Awesome..! simply but useful tricks.. Thanks Chandeep 👍
Thanks Antonio :)
Awesome sir🎉❤ thank you
Sudo tables are great!
Thank u very much 🙏!!!!!! Useful info
Always amazing tricks! That PQ second trick and DAX (MAXX) trick really bananas!!
We are waiting you Power Query Master class 🤘
Great,
Dax king.... ❤️
Cheers Nirmit :)
Amazing tricks!!
хорошая рубрика. Удачи.
Nice tips overall!
I feel embarrassed, but I have been struggling with reverse filtering in several cases and haven't been using a consistent method to bypass that limitation properly. So big thanks for DAX trick #2 and getting to understand the concept behind that.
Neat tricks. I enjoy it.
Can you share more context about using Column Reference as a filter argument for CALCULATE Function.
That pseudo table part was great Chandeep.. Nice content as always! 🤟Loved it.
The tip about the Lock Object had already been shared on some previous days' tips😁😁
Maxx is really awesome 👍
Excellent Hacks and got to know some new hacks especially in Power Query😍😍
Thanks Praveen
Understanding DAX in its depths is sometimes not too easy for me. As always, your tricks help me to get better. A big Thank You!
Happy to help :)
@@GoodlyChandeepI have a question sir on power query
Super Duper Awesome..
Perfect 👌
Amazing tricks, today itself I was working on matrix and there's the task to increase the width of columns , shift left and right key works wonder!
Thanks Itiksha :)
pseudo table part is a fantastic hack
very good
Unfortunately, I am in Iran and do not have the possibility to obtain your wonderful course.😢
Cool! Thank you.
Super!!
Pure gold and so much frustration can be avoided now.
😂
Goodly always has good stuff and this is no exception
How do you resolve "File contains corrupted data"
Can DAX measures be locked? So that someone doesn't delete or change it?
Awesome
Some pure nuggets there, thanks Chandeep!!! Just wish I could set column width similar to excel and choosing multiple columns to set width. I'm aware of the measure method with x 0's for example, but that doesn't seem to work if my matrix table consists of multiple measures to populate the values. 😢
Like to contact you personally to get to know about power BI training.
'mazing!!
Can we use power bi without registration
Yes, you can, but there are some limitations.
❤❤
filter doesn't work anymore
All banana 🎉🎉🎉
Ummm... Missing from Download file: Sales - "D:\OneDrive - Goodly\Online Trainings\Power BI - Pidilite\DAX and Modeling\Data.xlsx"
Products - "D:\OneDrive - Goodly\Online Trainings\Power BI - Pidilite\DAX and Modeling\Data.xlsx"
goodly.co.in/wp-content/uploads/2023/08/9-Power-BI-Tricks.zip