Forum Discussion
show the first row value from rows wtth same date
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,
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 quicklyThanks, its working!
Thanks!
5 Replies
- anmolmalviya05
Super User
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
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:
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
Thanks, its working!
