"dax script" union date
1 TopicUNION() on date field containing blanks
I have a DAX Query in my .pbix. In the script, a UNION() either takes ages or doesn't finish at all and has to be cancelled. This only happens when the tables in question contain a date field and some of the dates are blank. The date field isn't the date on a Date Table, it's just a plain simple data field. The problem goes away if the same date field has been transformed to be a text field. Why does this happen and how can it be resolved? The attached .pbix illustrates the problem as simply as possible. The scenario is currently set up to fail. The commented-out line of M code prevents the issue but of course leaves a field that should be a date as text. Thanks. UNION() on date field containing blanks.pbix Sale.xlsxSolved1.8KViews0likes9Comments
