Forum Discussion
Solved
Count the changes made on fields in a order compare to previous value in the same order.
I have a requirement to get the count of the manual changes users made on the given fields.Order co , Order#, Ordertype and Line # are unique. Here is the data set. Can someone advise me on how to co...
I will suggest to use column and not a measure for this.
Tip: Best is to get in the power query than using DAX!Dax Column syntax (and not measure syntax): For some reason it is not allowing to provide the DAX here, please check below as the reply :-)Row Index By Group = ROWNUMBER( ALLSELECTED(tbl[Order Co], tbl[Order Number], tbl[Or Ty], tbl[Line Number], tbl[Item], tbl[Request Date]), ORDERBY( tbl[Item], ASC, tbl[Request Date], ASC), PARTITIONBY(tbl[Order Co], tbl[Order Number], tbl[Or Ty], tbl[Line Number])) - 1
sevenhills
Super User
Super UserI will suggest to use column and not a measure for this.
Tip: Best is to get in the power query than using DAX!
Dax Column syntax (and not measure syntax): For some reason it is not allowing to provide the DAX here, please check below as the reply :-)
Hey, Sevenhills, Excellent. It serves the purpose. Thank you!