Forum Discussion
Solved
IF date is blank, pull date from different table
i have 2 tables with target closure dates. I'm trying to write a DAX/formula IF statement that will go "if [tableA] target closure date is blank, populate with [tableB] target closure date, else...
Hi megg8 ,
If it's a date field, then just change it from text type to date type and then try the formula as above to see if it works?
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
that was the problem, one of my dates had a data type of text.
Hi megg8 ,
If it's a date field, then just change it from text type to date type and then try the formula as above to see if it works?
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.