Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
am trying to get a total sales value of all invoices for a particular promotional date. The set analysis I have written is as follows but does not seem to be working. Can anyone let me know what I am doing that is incorrect
many thanks
=sum({$<Invoice_Date = {$(=Promo_Start_Date)}>}[Sales_Value])
try with date(Promo_Start_Date)