topic Re: show the first row value from rows wtth same date in DAX Commands and Tips

show the first row value from rows wtth same date

tamfod — Tue, 14 Jan 2025 08:50:28 GMT

The last two rows of the "Halmozott" column have the same value. I want a formula that displays all values in the next column except those with the same date. For these, only the first one should display the value, and the second one should display nothing,

Re: show the first row value from rows wtth same date

anmolmalviya05 — Tue, 14 Jan 2025 08:57:12 GMT

Hi , Hope you are doing good!

Filtered Value =
IF(
RANKX(
FILTER(
TableName,
TableName[Dátumok] = EARLIER(TableName[Dátumok])
),
TableName[Dátumok],
,
ASC
) = 1,
TableName[Halmozott],
BLANK()
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for Microsoft Fabric and Power BI updates: https://www.youtube.com/@AnmolPowerBICorner

tamfod

Re: show the first row value from rows wtth same date

tamfod — Tue, 14 Jan 2025 10:17:24 GMT

Thank you for your halp.

Your solving gives the next:

In the new culomb the data the same as the "Halmozott". I would like the next result:

Re: show the first row value from rows wtth same date

Anonymous — Thu, 16 Jan 2025 07:02:33 GMT

Hi tamfod ,

If you can add an index column in Power Query Editor, it will be easy to implement it.

Steps:

1.Add an index column.

2.Create a calculated column.

Szurt Halmozott = VAR _min=CALCULATE(MIN('Table'[Index]),FILTER('Table',[Datumok]=EARLIER('Table'[Datumok]))) RETURN IF(_min=[Index],[Halmozott])

Best Regards,
Stephen Tao

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

Re: show the first row value from rows wtth same date

tamfod — Fri, 17 Jan 2025 14:15:28 GMT

Thanks, its working!

Re: show the first row value from rows wtth same date

tamfod — Fri, 17 Jan 2025 14:16:59 GMT

Thanks!