Different data depending on current month

[Anonymous]

Hi there,

I have a table of data and I want to only show records when the created on date is this current year if the current month is April onwards, but if the current month is before April, then I need the current year's records and all of last year's records.

Has anyone got any good ideas / can point me in the right direction please?

Many thanks,

Andy

[Anonymous · Accepted solution]

No worries sorted it - possibly not the most efficient but it works - I created a new measure as below!

Include Record = if(and(year(max('Cases Table'[Created On Date]))>=year(today())-1,MONTH(today())<4),"Yes",if(and(year(max('Cases Table'[Created On Date]))=year(today()),MONTH(today())>3),"Yes","No"))