Forum Discussion

Icon for Post Prodigy rank

Post 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...

asocorro
10 years ago
Here it is:

Icon for Skilled Sharer rank

Skilled Sharer

10 years ago

Here it is:

ruthpozuelo
Post Prodigy
10 years ago
Of course, thanks!
/Ruth
ruthpozuelo
Post 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
  Skilled 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
    Post 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 :)

Related content