Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Below is the BOM list based on the latest effective in date.
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!
Solved! Go to Solution.
Sorry, I just figured it out. anyway, thank you all.
Any thoughts there? Thanks
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |