Forum Discussion
Return date calculation based on text
I have a text column with values and then a date column. What i am trying to do is if the text column contains a certain word, then calculate the date difference between the date and today. If the text column has a different word, then I do not need the calculation.
Hi paulhazelwood ,
Please try:
Column = IF(ISBLANK(SEARCH("Hold",'Table'[Value],,BLANK())),BLANK(),DATEDIFF('Table'[Date],TODAY(),DAY))Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
5 Replies
Hi paulhazelwood
Date Column Do you have Seperate columnb or not?
Can you share the any Ex Pic?
Thanks,
ThennarasuSorry unable to provide screenshot, but if you picture a column with dates (column A) and a column with text values (column B). What I want is a 3rd column that if Column B contains "word" then calculate datediff between date in Column A and TODAY.
