Forum Discussion

rebam12's avatar
rebam12
Helper I
1 year ago
Solved

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  ...
Data Protection
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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.

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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.