How to Identify First Month of Every Year?

Drushya · March 21

PujithaB · March 21

Hi @Drushya

You can find it using the below line items.

Let me know if this helps out.

Dikshant · March 21

Try this:

MONTH(ITEM(Time)) = 1

rob_marshall · March 21

@Dikshant nailed it, his is the best answer and will perform best because it has fewer calculations.

Best Answer