make values blank if its in the previous months

[Anonymous]

Hi All, 

i have this dataset that is connected to a date table. I would like to have the column in green where my figures are the same as the column on the left except for the period jan to march (months less than this month), i want it to be left as zero/blank. So the formula might look like if the date is thismonth or less then give me the "value" column else 0. But i just dont know how to write it. thanks alot in advance!!!!! Please note that this has to be a measure not column. 

THANK YOU!!!

[Jihwan_Kim]

Hi, @Anonymous 

Can you try like below?

What I want as Measure =

VAR currentdate = today()

RETURN

IF( MIN(Dates[Date]) < currentdate, BLANK(), YOURMEASURE!!)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[amitchandak · Accepted solution]

@Anonymous , Assuming month year coming from date table and table having date. And value is a measure.

Try a measure like

if(max('Date'[Date]) <= eomonth(today(),0),0,[values])