Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
This idea , solving my problem
https://community.powerbi.com/t5/Desktop/IF-AND-3-Conditions/td-p/280643
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.
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"
This idea , solving my problem
https://community.powerbi.com/t5/Desktop/IF-AND-3-Conditions/td-p/280643
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |