DAX Fridays!

Подписаться 138 тыс.

Просмотров 23 тыс.

50% 1

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

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 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 👂

@fajnefajne4339 Год назад

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

@fintoncassidy3518 Год назад

You are the greatest

@RobertoStaltari 3 года назад

Eager to see video tomorrow. Thanks Ruth

@CurbalEN 3 года назад

@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!

@scotttokaryk3714 3 года назад

This is brilliant. Thank you.

@CurbalEN 3 года назад

Thank you :)

@Kim_Tucuju 3 года назад

Brilliant! Thank you very much

@CurbalEN 3 года назад

🥳🥳

@shivanihandore4738 Год назад

Thank you so much 😇

@nawerdarbi Год назад

Thank you! 🌺

@RAFIKSAMY2008 3 года назад

Thanks lot

@solarson_studio 3 года назад

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

@Giovanni-vx8xl 2 года назад

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

@endivishayam1347 3 года назад

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

@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?

@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.

@greisboy425 6 месяцев назад

cool :)

@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.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7ZZTP8NJ2QM.html

@beingmoon1458 3 года назад

Nice

@RavinderKumar-cj3gc 3 года назад

Really amazing videos. i need tanning video can provide me.

@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

@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!

@mikel5180 3 года назад

Could you please post the database we are supposed to use in DAX Fridays, Thank you.

@CurbalEN 3 года назад

Absolutely, here it is: m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-k3NMIlLffrU.html

@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.