Forum Discussion
Solved
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 sh...
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!
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!