Forum Discussion

emma313823's avatar
emma313823
Icon for Helper V rankHelper V
5 years ago
Solved

Date heirarchy

Hi All, I'm a bit confused on this. In my data connected to the Desktop app I have in fields Billings. In Billings...there is a Commission Paid Date and and Invoice Date. I need to create two heira...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi emma313823 ,

     

    If there is a one to many relationship between the calendar table and the date field in the fact table, the date hierarchy in the fact table will disappear. You need to manually create the year, quarter, month and day column, then create the hierarchy


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi emma313823 ,

 

If there is a one to many relationship between the calendar table and the date field in the fact table, the date hierarchy in the fact table will disappear. You need to manually create the year, quarter, month and day column, then create the hierarchy


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.