Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

How to Display a record using DAX after data manipulation

Hi all,

 

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

 

 

 

 

 

 

 

 

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

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi All,


I have figured this out, I had a little help from another post, so more kudos to @jdbuchanan71.
Final.PNG
Here is the pbix. https://www.dropbox.com/s/r5fhx990wt9zknr/DateTesting%20Completed.pbix?dl=0 

Hope this helps someone...

Many thanks

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi All,


I have figured this out, I had a little help from another post, so more kudos to @jdbuchanan71.
Final.PNG
Here is the pbix. https://www.dropbox.com/s/r5fhx990wt9zknr/DateTesting%20Completed.pbix?dl=0 

Hope this helps someone...

Many thanks

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.