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

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

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.

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

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.

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!

But the results come out the same as the Total countrows when we put into card.

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?

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?

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

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?

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

You saved my night!

Great video! 🥳 You saved my job! 🤓

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?

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

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

THANK YOU!!!!!

It helps me and it will help others.

It worked! Nicely explained here 👏

Is there a way to use the same slicer from calendar table to slice two different tables (table 1 using start date ; table 2 using end date)

Can i have file to Practice?

Nice video. What if you wanted to count the number of rows that are after the one date but before the second date? I'm thinking that for each date, you need to calculate the number of dates before the later date, and the number of rows before the earlier date, and subtract one from the other?

Thanks Fernand! Very Helpful!