Forum Discussion
Different data depending on current month
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
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"))
1 Reply
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"))