date is greater than first date of every month

[capriconuser]

i have values these

startdate

1/1/2019

4/10/2019

1/1/2019

4/5/2019

1/1/2019

now i want to apply condition if this date is greater than first date of every month then i want to apply condition  start_Date - calendar_sart_date +1

how i do this 

[Vegar]

Try this:

LOAD
   IF( startdate > monthstart(startdate),   
       start_Date - calendar_sart_date +1, 
       startdate) as startdate,
...

FROM ...