Skip to main content

Hi Team,

 

How to create calculation previous month sales i need every month 1st &2nd & 15th &16th. current month 1st to till date.

Please help me how to create calculation.

 

Please find the attached file.How to create calculation previous month sales i need every month 1st &2nd & 15th &16th. current month 1st to till date.Regards,

Tgv

3 个回答
  1. 2023年11月29日 16:40

    Well, since that's just the same image as in your question, a little more clarification might have helped, but I'll take a guess.

    DATEPART('day',[Order Date1]) IN (1,2,15,16)

    OR

    DATETRUNC('month',[Order Date1]) = DATETRUNC('month',TODAY())

0/9000