relationships with date

[rebam12]

hi 

just for practise i downloaded healthcare dataset from kaggle  

suppose table1 is the name of table

there is only 1 excel sheet and in that there are 2 columns of date. 

1) date of admit 

2) dischage date

now i create another calendar table and add year month and day and date (2019 to 2024) columns

now how i idenltify reationships? like  calendar table date column to link with which date column in  table1 .. and what relationship should create ?

help needed

[rajendraongole1 · Accepted solution]

Hi @rebam12 -If your primary focus is either admissions or discharges you can derive the relationship between calendar to admit date or discharge date as follows

Calendar[Date] → Table1[date of admit] (if focusing on admissions)
Calendar[Date] → Table1[discharge date] (if focusing on discharges)

suppose you need to provide analysis with the inactive relationship is typically marked with a dotted line. You can then use DAX to activate it when needed using the USERELATIONSHIP function. highlighted.

Active Relationship: Calendar[Date] → Table1[date of admit]
Inactive Relationship: Calendar[Date] → Table1[discharge date]

Hope this helps.