if condition with date format table

[Anonymous]

I have a date table which has the date format in it. I want to use it in an if condition statement where if(date)=12/4/2020 , "show values of that date"  else 0. 

for the same i first created a measure to select value from the date table(as according to my knowledge the date format table cant be directly used or calculations):

measure= selectedvalue(date)

After that i wrote a formula:

if(sheet1[measure]=12/4/2020, goals,0) 

The value is coming to be 0 always even though there is a value of goals for that particular date

Can someone please help me out for the same

[V-lianl-msft]

Hi @Anonymous ,

Please try:

if(MAX(sheet1[date])=DATE(2020,12,4), goals,0)

If you want to reference a column in the measure, you need to aggregate it first. For date format values, you can't directly use text format. You need to use the date function to convert it to date format.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11 · Accepted solution]

HI @Anonymous ,

Check the format of DATE column in dates table and the measure that you created.

Measure should return a date type value, so make sure it's format is exactly same to what the format of DATE column in dates table is.

Thanks,

Pragati