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:

     

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

Now, this is quite odd,

 

I stopped refresh on the first query and included it in the second query to compare both tables, the refreshed and unrefreshed one.

Query 1: unrefreshed

Query 2: refreshed

 

My surprise was that when I refresh the Query 2 (that includes Query 1), Query 1 is also refreshed inside query 2, But Query 1 remains unrefreshed..Perhaps useful in other cases but not for this case. 

 

Any ideas on how to disable refresh with M?

 

/Ruth

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 :)