Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
5 years ago

More USERELATIONSHIP Problems adding a drill through table

I am starting to think that attempting to USE USERELATIONSHIP for a none active join is a bad idea because im constantly hitting problems. Looking at the following example again   So this ...
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey DebbieE ,

 

there is no DateB, only your values change.

You would have 2 measures:

1. FactDateA. This is using the normal relationship.

2. FactDateB. Here you change the relationship with USERELATIONSHIP.

 

In your report you put the date from the date table in your visual.

If you put in FactDateA you will see the value 30 on 01 Jan 2021.

If you put in FactDateB you will see the value 30 on 01 Mar 2021.

 

Like this, you can analyze both. But the date column you are using is from the date table and is always the same. Only the values change depending on the measure.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

 

DebbieE's avatar
DebbieE
Community Champion
5 years ago

1. FactDateA. This is using the normal relationship.

2. FactDateB. Here you change the relationship with USERELATIONSHIP.

 

But these arent measures? In terms of dragging in date B how would you create that measure?

 

There is no identifiable measure here. Its a date. I understand how to use USERELATIONSHIP when Im creating for example Last Years Sales, Or Year to date sales. But this isnt the same