How to Display a record using DAX after data manipulation

[Anonymous]

Hi all,

I have this issue that I am trying to work out and it's not going well. 

So here is my desktop, The data at the top is the total dataset. https://www.dropbox.com/scl/fi/q3y8yubzcg291ev6s7b68/TestData.xlsx?dl=0&rlkey=di73nqf93gs8w3mu0a5xme...

And the Pbix. https://www.dropbox.com/s/v0e0y6uznnmvh44/DateTesting.pbix?dl=0

So an explanation is required. On a certain date only one of the dataset should be displayed. Only by using the 3 different From and To dates can I determine which record that is.

The keys for dates, are showing the values of the keys that could be for that date. The record to display will be the key that is in all three pots. I have tried to do this a number of ways, and now I am frustrated. PeopleKey is supposed to be adding up the occurances of the Keys, the one with a Count of 3, would be the record to display. This is handled wih table DisplayRecords.

My question is, how can I get the display to work correctly. I don't understand how I can get UseKey to give me the correct answer. I think the solution is to get the keys together somehow. I tried using the NORMALINNERJOIN but this only gave me the first record all of the time. So even if I changed the date, displayRecord would have the first key only.

I hope that someone can look at this and say, why and show me the error of my ways. I am very new to this, I did an induction last week, however it didn't include how to manipulate data in this way.

Many thanks

 

[Anonymous · Accepted solution]

Hi All,

I have figured this out, I had a little help from another post, so more kudos to @jdbuchanan71.

Here is the pbix. https://www.dropbox.com/s/r5fhx990wt9zknr/DateTesting%20Completed.pbix?dl=0 

Hope this helps someone...

Many thanks