Forum Discussion

Sertan_CPH's avatar
Sertan_CPH
Frequent Visitor
5 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.