3 Insane DAX Tricks - You Probably Don't Know About

Рет қаралды 11,607

Күн бұрын

In this video, I will explain three helpful Power BI DAX tricks you never thought possible.
🌐 Blog post by Antriksh Sharma - www.antmanbi.com/post/using-d...
• 3 Insanely Awesome Sli...
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/learn-m-powerquery/
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/3-insane-dax-tricks
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!

Пікірлер: 46

@GoodlyChandeep Ай бұрын

Download the file ⬇ - goodly.co.in/3-insane-dax-tricks 3 Insanely Awesome Slicer Tricks in Power BI 🤯 - kzfaq.info/get/bejne/rJqoZcRpsti0c6M.htmlsi=gzWyQavALqTtiO40 Also, I have great courses on Power BI and Power Query. Don't forget to give it a shot 😉 - goodly.co.in/products.

@user-bg7tw8xo7e 27 күн бұрын

thank you so much for the content you have been posting on KZfaq Channel. May I suggest/ask something? Can you please teach us how to create a multilanguage Dashboard in Power BI? I have looking for something on Google, and KZfaq and so far I couldn't find anything. Please, can you help me with this?

@bresabboo619 25 күн бұрын

Awesome, all three are great especially the third trick. Thanks Chandeep

@labcdel4384 18 күн бұрын

Chandeep your ability to breakdown such complex topics and teach them so well is simply amazing

@gennarocimmino Ай бұрын

Three fantastic tricks that seem simple after the explanation, but only because of your great ability to make complicated things simple. Thank you for sharing this tutorial.

@GoodlyChandeep Ай бұрын

Happy to help :)

@curiousnam 9 күн бұрын

Such useful tricks , 2nd one was something i didn't knew about , Got to learn something new , thanks Chandeep!!

@user-mh2zy2gs4w Ай бұрын

I like the second trick. I was looking for a solution similar to that, where I can store the logic of the time intelligence calculation, for example YTD/QTD/MTD/PY in one place. My hope is to keep all the logic of the time filters in one place, and then apply those filters to the actual measures like Total Sales YTD/QTD/MTD/PY, Total Cost YTD/QTD/MTD/PY, Total Qty YTD/QTD/MTD/PY. By doing that, we will make sure the time intelligence are calculated at the exact time frame across the board

@Evaldas65 Ай бұрын

Calculation groups are your friend in that case :)

@fanlovexcel 20 күн бұрын

All the three tricks are awesome😊 The first one is very creative that creating a table reference to the Calendar. The second one is like calculation group a bit, cool! The last one is Wow, never think of that strick equal sign😮

@syrophenikan Ай бұрын

All 3 are fantastic!!!

@The_Excel_Enthusiast6782 Ай бұрын

Stellar video! I am also really enjoying your courses!

@bryanlau3216 Ай бұрын

Very good content. Thank you soo much

@ThePilli41 Ай бұрын

Wow, I have not seen that coming! This is simply amazing.

@pavelandreev6023 28 күн бұрын

Tnx. Really great!

@NirRobinson 29 күн бұрын

Great video. Regarding the 1st trick. Can we implement the same without additional table.? Captured the relevant month in Dax Add remove filter And filter by less than the relevant date. Pretty similar to what you showed but replace the additional table by bit complex Dax code probably Thanks again. Moving to trick #2😂

@Evaldas65 Ай бұрын

The second trick is brilliant! Thank you, didn't know about it, it will come in really useful when I need a complicated filter :)

@MikeFicetola Ай бұрын

Great! thank u

@user-bg7tw8xo7e 27 күн бұрын

@GoodlyChandeep , thank you so much for the content you have been posting on KZfaq Channel. May I suggest/ask something? Can you please teach us how to create a multilanguage Dashboard in Power BI? I have been looking for something on Google, and KZfaq and so far I couldn't find anything. Please, can you help me with this? thank you

@xeeshanahmad8757 Ай бұрын

Well done Boss. ❤

@samirvaghasiya9918 Ай бұрын

Thanks :)) Useful tricks

@Acheiropoietos 25 күн бұрын

Goodly by name, Goodly by nature 👍

@martyc5674 Ай бұрын

First one most useful for me- but all 3 are great 🎉

@anamqureshi802 Ай бұрын

Very Nice

@narayanjena4259 28 күн бұрын

Great

@cathrerinezetadrones3169 Ай бұрын

Is it not possible to define a detail row expression in power bi? Is this type distinction visible in the semantic layer of power bi?

@shaileshtp Ай бұрын

Tnx

@crownambassador1 Ай бұрын

This is a great idea, thank you. In the disconnected table, you can have only Month & Year field if the intention is to use it as a slicer . Store less fields , lesser the size of the pbix file.

@GoodlyChandeep Ай бұрын

Agree 💯

@smb0221 Ай бұрын

Very helpful. One question - in the first trick, the numbers are showing the comma separator between million/thousand after two digits. What causes that?

@justapasserby69420 Ай бұрын

That's not an error. That's the number format in India

@GoodlyChandeep Ай бұрын

That's an eye for detail. That's the way numbers are formatted in India.

@karimallahwala7022 Ай бұрын

Great and very helpful Video. Thank you so much. I think it is called „Lakh“ for 100.000 . So 5 „lakh“ is 500.000. „Crore“ is 10 millions. Makes me remenber my father he was always callacuting in this Units and we children didn‘t understand it in Germany. RIP Abbu.

@randomguy-jo1vq Ай бұрын

Trick Number 1: 1:00 Trick Number 2: 4:05 Trick Number 3: 8:07

@namangarg7875 Ай бұрын

Sir in the first trick letz suppose I have multiple visuals in the page and I want to do it only for a particular visual and for the rest of the visual it shud pick it from the slicer but in your case it is disconnected table how to achieve it then?

@balaramanramkumar Ай бұрын

You can use edit interaction for other visuals

@mienzillaz 27 күн бұрын

2nd: need to check if that will work for RLS

@larmondoflairallen4705 Ай бұрын

If you get tired of the "KZfaq thumbnail face" expressions (which you have mentioned previously as an occupational hazard), you should experiment with some AI to get Picasso-esque variations, like two mouths where the eyes go.

@GoodlyChandeep Ай бұрын

That's a really good idea 💡😁

@Ratnakumarwrites Ай бұрын

Hey Chandeep... Could you please do a video on TIMETABLE (Not the CALENDAR TABLE)... searched all over KZfaq and found nothing in this regard.... I am working on Case history data of Salesforce... Case ageing requires up to seconds level granularity... This particular topic has no video....

@GoodlyChandeep Ай бұрын

Send me some sample data, your question and the expected answer goodly.wordpress@gmail.com

@Ratnakumarwrites Ай бұрын

@@GoodlyChandeep Sure... Chandeep will share some data..

@geineralbertomejiagarzon4034 Ай бұрын

For the first trick, I guess that It works too using SELECTED VALUE instead of MAX, right?

@GoodlyChandeep Ай бұрын

It won't unless the disconnected table is at the granularity of a month

@geineralbertomejiagarzon4034 Ай бұрын

@@GoodlyChandeep got it, thanks

@Wzxxx Ай бұрын

Wow. The detailrows function? ..i did not know about it! Great but I really don’t like that this is not possible from clean BI (without Tabular editor)