Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ALL,
Sounds pretty simple but isnt working.
I have a simple table.
TaskName Task Created date
Task A 2021-09-30
Task B 2021-09-29
Now I want to display Task name where Task Created date = todays date.
So to accomplish that , on the table properties -> Data Handline -> Calculated Condition -> [Task Created]=today().
The result is the table isn't displaying anything while I expected to display the first record because today() returns 2021-09-30.
Anyone has any idea?
Thanks
Hi,
May be you can use below expression on dimension.
Expression : =Aggr(Only({<[Task Created date] = {'$(=Date(Today(),'YYYY-MM-DD'))'}>}TaskName),TaskName)
Uncheck Include null values
Thanks,
Ashutosh
Hi,
May be you can use below expression on dimension.
Expression : =Aggr(Only({<[Task Created date] = {'$(=Date(Today(),'YYYY-MM-DD'))'}>}TaskName),TaskName)
Uncheck Include null values
Thanks,
Ashutosh
Thanks Ashutosh, that worked.