Forum Discussion
Row_Number (By Partition)
Hi I saw identical question so using the same I am also looking for ; Select DateKey ,Line_Number,
Suite_name,
Group_Name,
Revision,
Status, Met FROM ...
Hi Anonymous,
Can you share a dummy sample please? It's hard to write a DAX without data and its structure.
Best Regards,
Dale
Thanks for your reply !!
Following is the sample, where Surr, Mid, NID and TIN are the physical columns and Seq column values are getting using Row_Number function code which I have shared in first post. There are few more additional columns apart from shown in the below snap so one column named [Met] is there and we want to SUM the values from column [Met] for Seq=1 like the way we are doing thru sql which can be found in first post.