I´m trying to format cell from date to text
Example, from Start date Jan 10 2022 to TBD,
This is because I don’t have a correct date Is it possible to do this?
Hi @Coachen
You may want to create a calculated measure (in Measures) where you substitute issue Start date value with any text (“TBD” or another). You can define any condition when to show the text: for those with future Start dates only or with any Start date value; add more WHEN conditions if you want to display different texts in each case.
The following calculation returns text TBD, if the Start date is in future:
CASE WHEN
DateCompare([Measures].[Issue Start date], "today")>0
THEN
"TBD"
END
Select formatting “text”.
Ilze / support@eazybi.com
Hi, thank you for the code example. I have managed to solve it so the input is “TBD” with future start dates.
However, I want to keep the original start dates in issues created before “today”. With the below written code i managed to get “TBD” in those fields but the goal is to get the actual start dates there.
CASE WHEN
DateCompare([Measures].[Issue Start date], “today”)>0
THEN
“TBD”
WHEN
DateCompare([Measures].[Issue Start date], “today”)<0
THEN
What should i put here?
END
Hi
Do you have any solution to my question?
//Gert
Hi,
I am sorry your last comment was left unanswered.
You may want to use function Format() to display any date (and numeric value) as a string:
CASE WHEN
DateCompare([Measures].[Issue Start date], "today")>0
THEN
"TBD"
WHEN
DateCompare([Measures].[Issue Start date], "today")<0
THEN
Format([Measures].[Issue Start date], "mmm dd yyyy")
END
Hope it works!
Ilze