Forum Discussion
How to create a 0...1/Many relationship
Hi Simone2004
You can't just insert the Payement date in the visual, you need to create a measure that will bring and insert that date into the visual. Use CALCULATE(SELECTEDVALUE( the date here), USERELATIONSHIP(column date from dimension_time , column payement date key from payments fact table)
where do I have to create the measure column? In the requests fact table? Dont I have to use a relationship between requests and payments by request_id?
Research how to create power BI measures.
the code is at the top of the screen and the measurements in the right corner.
yes, but to create a Measure I must select a table... Which table do I must select?
- The payments fact, make no sense I suppose;
- The requests fact, I suppose I must create a relation between requests fact and payments fact in the DAX Function... no?
Why do you need to add a column, you just need to create a measure to call the date of payments and then add that measure to your visual.
Did you try the measure I asked you to add?