How to use USERELATIONSHIP to handle MULTIPLE DATES in Power BI / DAX Basics 2021

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

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

50% 1

In this video I demonstrate how you can use the DAX function USERELATIONSHIP to work with datasets that have multiple dates.
-
Get started with Power BI Desktop FREE
powerbi.microsoft.com/en-us/d...
USERELATIONSHIP Documentation
docs.microsoft.com/en-us/dax/...
Create a Date Table in Power BI
• How to Create a DATE T...
-
🚩 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

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

14 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

Комментарии : 29

@yourcfoguy 8 дней назад

It worked! Nicely explained here 👏

@deejohn064 Год назад

Very straight-forward and a great example - saved my job :) Thanks!

@SolutionsAbroad Год назад

I appreciate the generosity man, thank you!

@giulianad.r1080 Год назад

Great video! 🥳 You saved my job! 🤓

@datalab365 3 месяца назад

It helps me and it will help others.

@gmartinezm Год назад

You saved my night!

@SolutionsAbroad Год назад

Glad it helped, thanks for watching!

@komotour 4 месяца назад

THANK YOU!!!!!

@bernardorainha7213 Год назад

good video, how would you do if you wanted to see a bar chart in which you wanted to have the number of active workers per month? In other words I had to work simultaneously with my start date and end date. How would i be able to do that by filtering by month and seeing the filtered month and the previous 11 months?

@ashokkumarpadmanabhan6483 8 месяцев назад

Excellent Video !!! Can you provide us source files you use in this videos for practice ?

@tingyanruan4744 2 года назад

Learn a lot from your channel. I was also wondering what if I got dates from different tables and I would like put them in the matrix how can I achieve it?

@SolutionsAbroad 2 года назад

Hi there, if you want to use dates from different tables, you'll need to create a relationship from them to your central calendar table

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

Thank you. I need only limited periods of data with inactive date. How can I use userelationship eg. > date(2020,1,1)

@rogercortez1 9 месяцев назад

Hello. Thank you for this video. It was very helpful in resolving a similar issue. One question I have is that, for example, let's say you also have a "business Unit" visual and you click on a specific bar on that business unit, the trend visual shows the active line, but it disabled the inactive line. If I deselect a business unit, then I can see both lines on the trend line. Any ideas how to address that issue?

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

Thank you for great work How to do that if the date passed its changing the bar color?

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

Hi there, thanks for watching the video! You might need to use the colour formatter and add a condition on it (in the line chart format pane, with the "fx" sign on it) Hope that helps!

@dddrrr7139 Год назад

can you do a video for a gantt chart or matrix using the same concept? but three different dates

@CiCi-il6op 2 года назад

Great video, perfectly resolved my current issue for a multi date chart - one more question, I am trying to add a tooltip page based on the date with no relationship with Date table, say " list the names of leavers when I hover on the chart? How can I do that? Thank you!

@SolutionsAbroad 2 года назад

Hiya, if it's not available in the Format Pane, then you'll need to be slightly creative with it. You can either create an invisible button, or other tricks like here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-a5HlBrBygVE.html

@CiCi-il6op 2 года назад

@@SolutionsAbroadNo issue in adding a tooltip, but I struggle with the tooltip report itself that lists all the names of leavers in the example in your video? What DAX can list the leavers names, as it is not a calculation. Thank you!

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

How to create MTTR ? I have incident opened day ID and resolved day ID in one table and Date in another table. I think it need to reference opened/ resolved day ID with Date table date but how to pull this ? can help ??

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

One question how can you make this link with a table, for example you have a line chart and a table and you want to click on a certain day on the line chart and see more info on the table. Because when I have tried it, it showed nothing on the table. Great video btw.

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

Hey Ammar, thanks for watching! Your line chart and table needs to have the same columns for it to work, As long as you're using the same columns from both your line chart and your table, this should work. If you're using two different tables, one for your table and one for your line chart, make sure you create a relationship so Power BI knows how your data is related. Hope that helps!

@cbsound007 Год назад

Hi, thank you for this video. I have multiple charts with different data from 2 dates and using slicer. The data in charts are coming fine but when I apply slicer date, the data is wrong because of the multiple date relationships. Any suggestions here?

@Jir0x Год назад

same issue here

@RamaKrishnan-qi3rb Год назад

@@Jir0x any luck?

@RamaKrishnan-qi3rb Год назад

Any luck?

@dafran500 2 года назад

Thanks for this video. However it is not working for me. Doing the exact same steps but when I use the date from the date table, the line chart goes blank.