cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Getting Today Stats, from day month and year

Dear Team

 

Need ur help to define my date

TodayDate.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Getting Today Stats, from day month and year

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Getting Today Stats, from day month and year

@syaifulefendi ,

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Resolver I
Resolver I

Re: Getting Today Stats, from day month and year

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

 

 

Highlighted
Community Support
Community Support

Re: Getting Today Stats, from day month and year

Hi @syaifulefendi , 

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

733.PNG

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")

734.PNG

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.

 

Highlighted
Resolver I
Resolver I

Re: Getting Today Stats, from day month and year

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"

 

 

Highlighted
Resolver I
Resolver I

Re: Getting Today Stats, from day month and year

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors