Forum Discussion
Solved
Add column or replace value?
Hello, I'm having some trouble puting a formula together to add a column that will return Sub Account 12345 for the first row in the table below. The account number for the department that needs to b...
Hi JSData
You can create a new column:
Column = var a=FILTER('Table',[Invoice Number]=EARLIER('Table'[Invoice Number])) return IF([Amount]>0,[Sub Account],MAXX(a,[Sub Account]))Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
