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

[Mjafar08]

Hi 

Need help
New to power bi and dax

I've a table 1 as 

Table 1
ID	Title	Date	count
123	i have a dream	06-Aug	100
123	i have a dream;	05-Aug	14
123	i have, a dream	04-Aug	15
123	I've a dream	06-Aug	1
123	van egy álmom	04-Aug	1
123	Tá brionglóid agam	04-Aug	1
123	ik heb een droom	04-Aug	1

and I want this table 2 as output

Table 2 : Output
ID	Title	Date	count
123	i have a dream	06-Aug	133

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

[v-zhangti]

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] )
)

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.

[Mjafar08]

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

[v-zhangti · Accepted solution]

Hi, @Mjafar08 

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.

[parry2k]

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

✨ Follow us on LinkedIn and  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.

[Mjafar08]

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'