DAX Fridays!

No video

DAX Fridays!

Рет қаралды 22,201

Күн бұрын

In today's video I will show you the dax needed to conditional format a line chart in Power BI and by doing that, I will show you the difference between SELECTEDVALUE and VALUES.
My second Channel:
• Charticulator #11: How...
Enjoy!
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/pro...
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Пікірлер: 47

@kalinduSekara 3 жыл бұрын

Wow. I didn't know that VALUES can be used like this. Thanks Ruth 😊

@ewad 3 жыл бұрын

Really missed these videos Ruth - thank you for an amazing new thing I learned today :)

@NaraMeerammaTrust 3 жыл бұрын

Very good one. Very much helpful practically. Thank you

@CurbalEN 3 жыл бұрын

Pleased to hear 👂

@sukoi2113 3 жыл бұрын

I discovered the use of "in values" after some struggle. But it was very efficient and "selected value" is forgotten now. Lol Thanks for this knowledge share. Fan of yours.

@CurbalEN 3 жыл бұрын

I find the syntax difficult, but the actual use case is brilliant!

@sukoi2113 3 жыл бұрын

And these tables are not to be linked. That's very important

@CurbalEN 3 жыл бұрын

Correct!

@fintoncassidy3518 Жыл бұрын

You are the greatest

@RobertoStaltari 3 жыл бұрын

Eager to see video tomorrow. Thanks Ruth

@CurbalEN 3 жыл бұрын

@fajnefajne4339 Жыл бұрын

I like this VALUES and SELECTEDVALUE and IN combination. Thank you. :-)

@scotttokaryk3714 3 жыл бұрын

This is brilliant. Thank you.

@CurbalEN 3 жыл бұрын

Thank you :)

@solarson_studio 3 жыл бұрын

Thanks for sharing. Can we understand SELECTEDVALUE returns row context, VALUES returns filter context?

@Kim_Tucuju 3 жыл бұрын

Brilliant! Thank you very much

@CurbalEN 3 жыл бұрын

🥳🥳

@Giovanni-vx8xl 2 жыл бұрын

Thanks for shearing. Do u have a video DAX for beginners? Thanks

@shivanihandore4738 Жыл бұрын

Thank you so much 😇

@RAFIKSAMY2008 3 жыл бұрын

Thanks lot

@nawerdarbi Жыл бұрын

Thank you! 🌺

@prashantk25 3 жыл бұрын

Is there any way to bring time on Y axis.. 10am, 11am, 12noon and so on.. I've certain process that finished daily at between 2 PM to 5 pm. Want a graph that shows date on x axis and the process end time on y axis. Unable to get this in power bi. Community didn't give any useful results. Any help would be appreciated.

@Tranquanghuy2111 3 жыл бұрын

Hi Ruth, may i ask you the name of the line chart in the beginning of the video? I really like the way it shows name of legend right at the end of each line. Thanks so much and have a good day

@CurbalEN 3 жыл бұрын

Charticulator I will show you how to create it on my second channel today. Stay tuned! Example: m.kzfaq.info/get/bejne/bcCKh7Nps7CWgYE.html

@Mojochetan 3 жыл бұрын

Thank You Mam, I have a question, do we need to create a seperate tooltip page everytime, if I want to show different data as a tooltip for different columns of single table. Or is there any different way?

@endivishayam1347 3 жыл бұрын

hi mam , can make video how many ways to create tables in power bi ???

@B1897forzajuve 3 жыл бұрын

Hi Ruth. I am new to your channel. I find your videos so useful. I have a particular problem in power query. I want to apply if and sumif condition at once. I know how to make if conditions , but I do not know what is the equivalent of SUMIFS in Power Query when looking up in another query. Can you please suggest something? Thanks.

@CurbalEN 3 жыл бұрын

The power bi community is the perfect place for those questions. Make sure you post sample data!

@totvabe1 3 жыл бұрын

Could we use ALLSELECTED() in the same way that VALUES() in this example?

@hoaninhnguyen6038 3 жыл бұрын

@Curbal, Hi after I finished watching the video, I still don't understand the difference between selectedvalue and values. Can you help me explain it again. thank you !

@CurbalEN 3 жыл бұрын

Selectedvalue returns a number and values return a table

@hoaninhnguyen6038 3 жыл бұрын

@@CurbalEN Thanks for your useful information. but maybe I'll have to watch this video again to understand.

@CurbalEN 3 жыл бұрын

Better yet, try to do it yourself and that might do it

@govardhanbola1195 3 жыл бұрын

I have a situation like this, for calculating MoM and WoW, I need to consider same period in the previous year. Let's say if I want to return MoM for August 2021, then calculation would be like (Aug_2021 sales - Aug_2020 sales)/Aug_2020 sales * 100. Like this it should be dynamic for MoM and WoW and in the view I need to display like Last 12 months for MoM % growth, and Last 13 months for WoW % growth. I achieved the calculation but not able to restrict last 12 months/13 weeks. Any help on this would be helpful. Note: we are not supposed to use calendar table as per our requirement. So considering sales_date from data itself and I achieved WoW and MoM based on month_number and Week_Number. And based on maximum sales_date, we need to display last 12 months or Last 13 weeks.