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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors