show the first row value from rows wtth same date

[tamfod]

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,

[Anonymous · Accepted solution]

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

[tamfod · Accepted solution]

Thanks, its working!

[tamfod · Accepted solution]

Thanks, its working!

[anmolmalviya05]

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

[tamfod]

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:

[Anonymous · Accepted solution]

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

[tamfod · Accepted solution]

Thanks!