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, the...
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"))
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"))