Forum Discussion
Simone2004
Helper I
Helper IHow to create a 0...1/Many relationship
Hi everyone, I have this model: A request can have 0 or 1 payments; Dimension_time is related to requests; Dimension_time (2) is related to payments. In the report, I just want to...
aj1973
Community Champion
Community ChampionHi 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)
Simone2004Helper I
Helper Iwhere 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?