Difference between calculated dimensions

[stevenpiers]

Hi,

I have 2 different calculated dimensions (CD) which result in an itemid. CD1 checks in a hourly updated database and CD2 checks in daily updated database.

e.g. CD2 results in 5 itemId's, CD1 results 10 itemId's

Question: > What are the unique itemId's ?

[Gopi_E]

Hi steven,

provide sample data, so it would be gives better understand what you exactly want.

[stevenpiers]

See simplyfied sample.

Thanks in advance for your advice.

[Taoufiq_Zarra]

can you explain your need again

[Gopi_E]

I am not understand what exactly you want.

you created two inline tables and loaded it. but as you said the both tables having different data so there is no combination between them.

[stevenpiers]

I'll try to explain.

There are 2 databases, one is updated hourly and the other daily.

let's say at 9 AM I know that the daily database has 10 items with an empty  value

at 10 AM I see in the hourly database 13 items with an empty value

The difference of 3 is an opportunity, but most likely, because there are people working with the data... it 's possible that the actual difference is that the 10 items from 9 AM are solved and the 13 items from 10AM are new. Or perhaps partly

Does this make it any clearer?

[Taoufiq_Zarra · Accepted solution]

I'm not if I understand correctly.

but try the attached version.

I created a connection between CD1 and CD2 using ItemId, then the "output" table I think it answers your question

[stevenpiers]

That's it! Thanks.... if I look at your expression I must admit I was thinking too difficult.

Again... thanks!

[Taoufiq_Zarra]

Awesome