Forum Discussion
Solved
Two table comparison based on date
In product development we keep bill of materials (BOM) with cost information. I upload the current BOM every week. These BOMs are aggrageted in a querry wich returns a table of BOMs appended together...
Hi Sertan_CPH
You can create relationships between two tables based on date ,and then detect whether the status for column 'functions' is changed .
Or you can use TREATAS() dax to transport filters from (unrelated) tables .
The usage for TREATAS() dax can refer to the link :
https://docs.microsoft.com/en-us/dax/treatas-function
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
Super UserI recommend you look at the TREATAS() function, it allows you to transport filters from (unrelated) tables, but it also allows you to do sliding window comparisons in the same table.