PI seems to have a BOM('*') time expression to signify the start of the current month. How about the last day of the current month?
E.g. how can this query be changed to show values at the end of each month?
WHERE tag = 'sinusoid'
AND time BETWEEN Bom('*-1y') AND '*'
AND timestep = '1mo'