Forum Discussion

ruthpozuelo's avatar
ruthpozuelo
Icon for Post Prodigy rankPost Prodigy
10 years ago
Solved

Compare two sets of data from the same source

Hi, An example, lets say I want to compare two sets of data from the same source, for example a bill of materials for a bike.   This data source changes when users update the data, but there are n...
Need Help
  • asocorro's avatar
    asocorro
    10 years ago

    Here it is:

     

asocorro's avatar
asocorro
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

How about doing the comparison in DAX?  One way would be to add a calculated column in the new table to do a lookup of the corresponding value in the original table and then compare them.

 

ruthpozuelo's avatar
ruthpozuelo
Icon for Post Prodigy rankPost Prodigy
10 years ago

Sorry for my Uber Late reply!

 

I was hoping to build a more automated solution, something like:

Click on refresh button, all queries are refreshed except for that table and then refresh that manually...sort of...

I already have a lookup in place, but it is not optimal...

 

Thanks for the support anyhow :)