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!
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!