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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
naoyixue1
Post Patron
Post Patron

How to catch the latest BOM item based on the latest effective in date

Hey there,

 

I try to create a table to highlight the latest BOM table. (see below master data) . In our master data table, it has all records of BOM with the effective in and effective out time). But i want to create a table to visualize the BOM at the production site level based on the latest effective in date (A and B are different type of components) 

 

Master Data Table

 

naoyixue1_0-1695270507445.png

 

Below is the BOM list based on the latest effective in date. 

naoyixue1_1-1695270792291.png

 

So my question is 

 

1: Not sure I should create a measure or column to have those info

 

2: How I should write the dax

 

Thanks a lot!

1 ACCEPTED SOLUTION
naoyixue1
Post Patron
Post Patron

Sorry, I just figured it out.  anyway, thank you all. 

naoyixue1_0-1695330963691.png

 

View solution in original post

3 REPLIES 3
naoyixue1
Post Patron
Post Patron

Sorry, I just figured it out.  anyway, thank you all. 

naoyixue1_0-1695330963691.png

 

naoyixue1
Post Patron
Post Patron

Any thoughts there? Thanks

naoyixue1
Post Patron
Post Patron

Adding the attachments for excel and pbix. 

 

See the dax I wrote, but it seems that doesn't help to split the BOM based on the production site. Any thoughts how I can calculate that at site level. Thanks!

 

naoyixue1_0-1695271819563.png

naoyixue1_1-1695271840046.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.