Getting Today Stats, from day month and year

[Anonymous]

Dear Team

Need ur help to define my date

Logic = if Date of Column DATE is the same with DAY of Today , Month of Today and Year of Today THEN remark TODAY else NOTTODAY

Note : today is June 2 2020

Thanks any help and respond

Regards

Syaiful

[dax]

Hi @Anonymous , 

I think your logic "Logic = if Date of Column DATE is the same with DAY of Today , Month of Today and Year of Today THEN remark TODAY else NOTTODAY" is to compare date with today, right?

If your date column is not date type, you could try to change it to date like below

Then try below calculated column expression

Column = if('Table (3)'[DATE - Copy]=TODAY(), "Today", "NotToday")

 If you Date type is text, you could try to use below expression.

Column 2 = if(FORMAT(TODAY(), "dd-MMM-yy")='Table (3)'[DATE], "Today", "NotToday")

Best Regards,
Zoe Zhi

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

[Anonymous]

Thanks anyway for ur idea ..
for not date type of data .

actually my data was a date type , im trying ur 1st idea, it show the result  but all return to Not Today , there is no "TODAY"

[Anonymous · Accepted solution]

This idea , solving my problem

https://community.powerbi.com/t5/Desktop/IF-AND-3-Conditions/td-p/280643

[amitchandak]

@Anonymous ,

New column = if(Table[Date]=today(), "Today", "Not Today")

Also

You have year(date[Date]) Or Year(Today()) , similarly you have month() and day() function

[Anonymous]

Thanks @amitchandak for ur respond

i tried ur 1st advice , failed , only show comment after 1st condition (mean else )

i dun really know much bout DAX, thats why im asking how to build 3 condition for IF