Hello, I'm working on a report that contains an appended table with three dates (created date, start date, completed date) within one table. If I add a date slicer for any one of these dates, it will not include all calendar dates for 2020. To remedy this, I created an independent date table, related the date field to all three of those dates in the model, but made the connection inactive. I tried using the relationship DAX formula in a created measure to relate the dates, but I cannot get the indepedent date table in the slicer to work. I want that filter to show results that include dates from any of the three date fields. What am I missing?
Thanks in advance!
Solved! Go to Solution.
@levelup if you have used these measures in your visual, and assuming you have used userelationship function in your measures to make an inactive relationship to active, all measure values will be shown based on the selected date range, and it should work. Please provide more context with example/screenshots if this doesn't answer.
I did try using the userelationship in a measure, but it didn't work. This variable is used in a visual to count tasks. The independent date slider is formatted as a date between filter, but when I slide it, it doesn't produce any results.
This is the formula I used. I tried relating it to one date, which didn't work, and then tried relating it to all dates, which also didn't work.
@levelup you will create 3 different measures, for create, due, and completion date, and in each measure you will use userelationship function and these use these 3 measures to visualize the data. I hope it makes sense.
@levelup yes 3 different measure, one for each stage. Maybe it will be easier if you paste sample data and expected output. Read this post to get your answer quickly.
@levelup , You can activate the joins using userelation as long you need the same dates to filter.
Means one date dimension all three dates can work
Sometime you may need two date dimensions - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601 (This is for one date. But you can do for two dates )