Forum Discussion

jatneerjat's avatar
jatneerjat
Icon for Helper V rankHelper V
8 years ago
Solved

Date hierarchy not available

Hi,   I have a custom date column "Date" so when i create a relationship between "Date" and another date column which i am getting from DummyDate = calendarauto() then the hierarchy for the custom ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    OK, I was able to recreate this. Seems like it depends on how the relationship is configured. See attached PBIX.

     

     

     

     

  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi jatneerjat,

     

    I have made a test with based on you description, it do have this issue.

     

    Actually, when you create the relationship (Many to one or one to Many) between the tables with Date, only the date in the one side will show date hierarchy. 

     

    If you want create the relationship (One to one ) and you want to the date in your fact table show date hierarchy, you could create the relationship like below.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi jatneerjat,

 

I have made a test with based on you description, it do have this issue.

 

Actually, when you create the relationship (Many to one or one to Many) between the tables with Date, only the date in the one side will show date hierarchy. 

 

If you want create the relationship (One to one ) and you want to the date in your fact table show date hierarchy, you could create the relationship like below.

 

Best Regards,

Cherry

  • jatneerjat's avatar
    jatneerjat
    Icon for Helper V rankHelper V
    8 years ago

    hi v-piga-msft,

     

    What to do if i have one to many relationship and i want date hierarchy in Fact table?

     

    Thanks,