Тёмный

How to use SELECTEDVALUE and HASONEVALUE in DAX // Beginners Guide to Power BI in 2021 

Fernan
Подписаться 45 тыс.
Просмотров 22 тыс.
50% 1

Get Demo Files here
ko-fi.com/s/f814dc9b98
In this video were covering how you can ensure calculations are done when only one value is selected, using SELECTEDVALUE and HASONEVALUE DAX functions.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of RU-vid.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

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

 

7 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 15   
@baleani1955
@baleani1955 Год назад
Your videos are really good and helps a lot. Reduces stress i have to say. Thanks
@sanianaeem8311
@sanianaeem8311 2 года назад
Thank you!
@sixtyfiveroses2968
@sixtyfiveroses2968 2 года назад
Perfect! thank you so much for this easy & fast solution, I've been struggling for a week now, wish I found this sooner.
@SolutionsAbroad
@SolutionsAbroad 2 года назад
Thanks for watching!
@sowjanyakake5720
@sowjanyakake5720 Год назад
Very easy explanation, thanks for the video..
@SolutionsAbroad
@SolutionsAbroad Год назад
Glad it was helpful!
@shreyamanjucha4621
@shreyamanjucha4621 7 месяцев назад
Multiple select value as a condition case?
@rekhab2003
@rekhab2003 3 месяца назад
May I know the difference between both
@govardhanbola1195
@govardhanbola1195 2 года назад
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.
@SolutionsAbroad
@SolutionsAbroad 2 года назад
For this youll need to use something like PREVIOUSYEAR in combination with the CALCULATE function something like this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dR-XmJil5DM.html If you aren’t supposed to use calendar tables, you can try to create a MoM or YoY using quick measures
@kiransake6674
@kiransake6674 2 года назад
We need your help if we stucked with dax
@SolutionsAbroad
@SolutionsAbroad 2 года назад
Hi Kiran, I can ask any questions you have here, as long as they’re short and relevant to the video, If you need a more tailored support, I provide it as a service, through memberships, Hope that helps!
@kiransake6674
@kiransake6674 2 года назад
Hey fernan if we have any doubts how can we contact you
@SolutionsAbroad
@SolutionsAbroad 2 года назад
Hi Kiran, normally you can just reach out to me here in the comments, if it's anything related to the video I answer them here
Далее
Впервые дал другу машину…
00:57
아이스크림으로 체감되는 요즘 물가
00:16
Using the SELECTEDVALUE function in DAX
12:27
Просмотров 176 тыс.
3 Ways to use Calculation Groups You Need to Know
20:00
Впервые дал другу машину…
00:57