Forum Discussion
relationships with date
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
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.
1 Reply
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.