Forum Discussion

topkapi's avatar
topkapi
Frequent Visitor
8 years ago
Solved

How to join multiple date fields from fact table to Dim Date table

Hi All,   I have an issue, I need to join 2 date fields from my fact table (Start_Date), (End_Date) with date dim. The table allows me only one join. Alongwith these 2 dates other factors are also ...
  • dawidvh's avatar
    dawidvh
    8 years ago

    Hi topkapi

     

    From the above, I understand that you are trying to generate a line chart to show the number of people who joined or left the organisation as displayed over a certain time frame (x axis). If this is the case, you can use USERELATIONSHIP in a measure for the date fields that have the relationships that are not active.

     

    Let me know if you dont come right.

     

    Display multiple date fields on line graph

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

topkapi's avatar
topkapi
Frequent Visitor
8 years ago

Thanks Ashish, looks helpful.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are welcome.  If my reply helped, please mark it as Answer.

    • topkapi's avatar
      topkapi
      Frequent Visitor
      8 years ago

      But I am still unable to provide a single dim - date on x-axis to see trend to both.

      • dawidvh's avatar
        dawidvh
        Helper I
        8 years ago

        Hi topkapi

         

        From the above, I understand that you are trying to generate a line chart to show the number of people who joined or left the organisation as displayed over a certain time frame (x axis). If this is the case, you can use USERELATIONSHIP in a measure for the date fields that have the relationships that are not active.

         

        Let me know if you dont come right.

         

        Display multiple date fields on line graph