无法从日期列测量 [英] Cant measure from date column

问题描述

我正在尝试计算completionDate"列中的日期与今天之间的天数

I'm trying to count days between a date from the column 'completionDate' and today

表名是事件 (2)"

我有一个名为事件"的模拟表，它正在工作.

I have a simuler table called 'incidents' here it's working.

代码:DaysClosed = DATEDIFF('事件 (2)'[completionDate].[Dag];TODAY();DAY)

我得到的错误:无法确定表事件 (2)"中completionDate"列的变体Dag"的单个值.当度量公式引用包含许多值但未指定聚合(例如 min、max、count 或 sum)以获得单个结果的列时，可能会发生这种情况.'

The error i get: 'A single value for variaton 'Dag' for column 'completionDate' in table 'Incidents (2)' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.'

推荐答案

'Incidents (2)'[completionDate].[Dag] 引用一个列.它在您的计算中返回一个表(评估上下文中的多个日期)代替 DATEDIFF 计算所需的标量.

'Incidents (2)'[completionDate].[Dag] referencing a colomn. It is in your computation returning a table (multiple date in the evaluation context) instade of a scalar needed in DATEDIFF calculation.

您需要利用以确保 'Incidents (2)'[completionDate].[Dag] 正在转为标量值.为此，您可以利用 rowcontext 和 Max 等公式.

You need to leverage to be sure that 'Incidents (2)'[completionDate].[Dag] is rturning a scalar value. To do that you can leverage rowcontext and then also formula like Max.

这篇关于无法从日期列测量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！