Forum Discussion
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 heirarchy's on both of these fields. Paid represents money in the door and Invoice represents a shipment date for us.
The data we are using comes from a company we use for our data entry. They provide me credentials and I am able to sync the data into the Power BI Desktop app. In the Data...they have a 'date heirarchy', but I'm not sure where the info is pulling from. I wanted to create I guess two date heirarchys for the above items and rename them such that I can use one where ship or pay dates where I want them. Can anyone assist in how to achieve this?
The dates I want to draw from are in my Billings table...
Thanks
Emma
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.
2 Replies
both of your dates need to be linked to a date table. What is the current structure of your data, are you dates linked to a date table? in your date table if you need to create specific hierarchies you can or you can just create one.
can you share your relationship view of your data?
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.
