Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multiple Date columns retriving from a table

Hi ,

 I have a table consissts of 

     

 ID       Status    Escalation   Review        Notice

 37  Active1/1/20177/31/20249/30/2024
14Active11/7/201912/7/20226/5/2023
25Active2/2/202010/5/202112/4/2021
49Active1/1/20202/3/20254/5/2025
38Active11/29/20195/3/20517/2/2051

 

i have calender table which has active relationship with escalation . how can i pull all date columns if i selected date column which have no relationship with Calender table

Need Help

4 Replies

  • rbriga's avatar
    rbriga
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Your calendar will have one active connection (to the escalation date). 

    However, you can still include the other tables in the column for other purposes.

    If you need other tables for specific calculations, you can set another relationship which will become inactive (for example, Review Date to Calendar Date). Then add the USERELATIONSHIP function in the Calculate function.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      Next Review Date = CALCULATE(SELECTEDVALUE(ContractsBasicDetails[Next Review Date]),USERELATIONSHIP('Calendar'[Date],ContractsBasicDetails[Next Review Date])) this is pulling only next review date . I want all three dates to pull.How can i achive it
  • rbriga's avatar
    rbriga
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    I'm not sure I understand. 

    For example, SELECTEDVALUE(ContractsBasicDetails[Notice Date])

    should pull the notice date according to the context (User/ date), even without the USERELATIONSHIP clause. Your tables are connected.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    is there any DAX function that pulls multiple date columns when connected to Calender table?