Forum Discussion
show the first row value from rows wtth same date
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!
Super UserHi , 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 quicklyThanks!