Adjusting a Unique Let Formula to add an additional column/value.

[nickpavlov]

Hello, I am looking to add to this formula.

In the example, I added a unique customer number, that I want to return also in the Let/Filter formula.

Please Login or Register  to view this content.

I appreciate any help.

Thank you,
Nick

[Fluff13]

How about

Please Login or Register  to view this content.

[nickpavlov]

Awesome! Thank you Fluff!

[Fluff13]

You're welcome & thanks for the feedback.

[nickpavlov]

Follow up, I need to use this for another purpose, can you assist with removing the date from the formula, I tried just removing the Table1[DATE]>TODAY()-30), but it messed things up.

I appreciate any help.

Nick

[Fluff13]

How about

Please Login or Register  to view this content.

[nickpavlov]

Awesome again, thanks Fluff.

[nickpavlov]

Ok, one more problem I am having. The sample I had uploaded, did not have the same number of columns and the same order.

I tried editing (b,,1) (b,,2) to line up with the correct columns, but it got really messed up

Is it possible to reference the table column names?

Attached is the issue I am having.

Thank you for any help.

Nick

[HansDouwe]

Yes it is possible to reference the table column names:

Please try

Please Login or Register  to view this content.

[nickpavlov]

HansDouwe, that works much better.

I realized that it would be better for the unique to be the number, and not the name. There could be people that have the same name, but will always have a unique number.

I was able to edit your formula, but can't figure out how to keep the order the same, Name, Number, Trans, Total.

If you are able to help, I would appreciate it.

Thank you,
Nick

[HansDouwe]

Please try:

Please Login or Register  to view this content.

[nickpavlov]

Awesome, thank you HansDouwe!

[HansDouwe]

You are Welcome!

Thanks for the feedback and rep . Glad to have helped.