Hi All
I need to issue invoices to customers who placed orders in the current month. And I need to add each invoice to invoice table.
Ok. I know how to create invoice for a customer. And I know how to create a slice with customers who placed orders in the month
But how to iterate over all customers and invoice for each?
You want to use the IN() function. In english … Get the list of Customers where the Customer ID is in the list of Customer who have invoices for the month.
An example expression might be:
SELECT(Customers[Customer ID], IN([Customer ID], Slice Customer Orders[Customer Ref]))
Article for IN() Function
https://help.appsheet.com/en/articles/2357277-in
I hope this helps!