Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
emma313823
Helper IV
Helper IV

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?

 

emma313823_0-1627072485296.png

 

The dates I want to draw from are in my Billings table...

 

emma313823_1-1627072564114.png

 

emma313823_2-1627072581484.png

 

Thanks

Emma

 

 

Emma
1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

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.

vanessafvg
Super User
Super User

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?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.