Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 [tableA] target closure date.
I tried the below, but kept getting "Expressions that yield variant data-type cannot be used to define calculated columns."
Solved! Go to Solution.
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.
Thanks for the reply from @vicky_ , please allow me to provide another insight:
Hi @megg8 ,
You can try formula like below and create calculated column in tableA:
True Target Close Date =
IF (
ISBLANK ( 'TableA'[Target Closure Date] ),
MAXX ( 'TableB', 'TableB'[Target Closure Date] ),
'TableA'[Target Closure Date]
)
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.
Is the data type the same? i.e both Table A closure date and Table B closure date are actually date type (and one of them isn't a number / string)... Otherwise, the issue might be that your column name starts with True, which might be a reserved word (i don't know for sure, because i can't find the docs for this)
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.
User | Count |
---|---|
83 | |
70 | |
69 | |
66 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |