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.
Hi Team
im back again with another question.
i want to get column result same as "REMARK" , i will keep date beside those date as blank ( "" )
i already used DAX below, but result not same as REMARK
Status_day = if(Table[DATE] = today(),"today", if (Table[DATE] = today()-1,"yesterday", if(Table[DATE] = today() + 1, "tomorrow")))
thanks
syaiful
Solved! Go to Solution.
@Anonymous
Well, I guess change the display format will not change essence of the value. You need to use Format function like @Anonymous did.
I recommend you create a new date column to format your date and remove the timestamps:
FORMAT('Table'[Date],"YYYY/MM/DD")
And then stick with your IF formula.
Paul,
Best.
Paul
Hi @Anonymous ,
You can create a calculated column in the table using below formula. As in your case, time is also available in the value hence we need to get date from timestamp field and need to compare.
i did .
but result only blank . i see there are data for today transaction but same result as blank .
any suggestion ??
my date already type as date and time format
@Anonymous
This is because your date column includes time frame. With your formula I have resulted the same blank for NOW() function, but works for Today() or created date column. So I think you would need to recreated your date column.
Paul
Best
hi paul
i already change type of date time to date only , but why result still blank also ??
@Anonymous
Well, I guess change the display format will not change essence of the value. You need to use Format function like @Anonymous did.
I recommend you create a new date column to format your date and remove the timestamps:
FORMAT('Table'[Date],"YYYY/MM/DD")
And then stick with your IF formula.
Paul,
Best.
Paul
I changed the date format to dd/MM/yyyy the applied the below formula. It worked for me...:)
can u show me ,,
u can attach new pbi here
thanks
Hi @Anonymous
Relative Date Dimension can help you achieve this requirement.
https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
relative filter gv me option while showing ,
my goal is getting name column ( yesterday | today | tomorrow ) , which only able to do with nested if from new column
Could you provide some sample dates. In my case i can see the desired result.
hi @Anonymous
this is my date format
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |