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
Solved! Go to Solution.
New column = if(Table[Date]=today(), "Today", "Not Today")
You have year(date[Date]) Or Year(Today()) , similarly you have month() and day() function
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
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
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")
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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"
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!