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, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Mjafar08
Regular Visitor

Power Bi Dsiplay value in table based on unique identifier(id)

Hi 

Need help
New to power bi and dax

I've a table 1 as 

Table 1   
IDTitleDatecount
123i have a dream06-Aug100
123i have a dream;05-Aug14
123i have, a dream04-Aug15
123I've a dream06-Aug1
123van egy álmom04-Aug1
123Tá brionglóid agam04-Aug1
123ik heb een droom04-Aug1


and I want this table 2 as output

Table 2 : Output  
IDTitleDatecount
123i have a dream06-Aug133



Want to display table 2 in the form of a table/matrix graph in Power BI 
any idea how to proceed

1 ACCEPTED SOLUTION

Hi, @Mjafar08 

 

Is this the result you expect?

vzhangti_0-1664185407849.pngvzhangti_1-1664185424593.png

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-zhangti
Community Support
Community Support

Hi, @Mjafar08 

 

You can try the following methods.

Table:

Table 2 = 
SUMMARIZE (
    'Table 1',
    'Table 1'[ID],
    "Title", MIN ( 'Table 1'[Title] ),
    "Date", MAX ( 'Table 1'[Date] ),
    "count", SUM ( 'Table 1'[count] )
)

vzhangti_0-1663920522470.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-zhangti 
Is there any way we can achieve this while dragging/dropping columns and then doing some transformation? For exa: we have ID,Title, Date, Count as fields and we want to achieve the output in the form of a table/matrix

Hi, @Mjafar08 

 

Is this the result you expect?

vzhangti_0-1664185407849.pngvzhangti_1-1664185424593.png

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k
Super User
Super User

@Mjafar08 what is the logic to summarizing the data? Why it is Aug 06th and not any other date?

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hi @parry2k 
You see 6th Aug is the latest date meaning a situation where we want to select the latest title based on date and max(metric) here 'Count'

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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