如何按季度计算视觉的唯一值

Question

我有一个权力的BI视觉喜欢附加的图像。客户名称和季度结束日期是表中的列。“未来客户”是一种衡量标准，它基于其他几种衡量标准。我想要Quarter1、Quarter2、Quarter3、Quarter4的唯一新客户数量。在此示例中-

Quarter 1 has 4 new customers
Q2 has 3 new customers
Q3 has 1 new customer
Q4 has 1 new customer.

​

​

Answer 1

按照以下步骤实现所需的输出：

Step-1为您的表创建一个**自定义列，如下所示：

new customer = 

VAR current_row_customer = your_table_name[customer name]
VAR current_row_quarter_end_date = your_table_name[quarter end date]

VAR find_customer_previous_quarter =
CALCULATE(
    COUNT(your_table_name[customer name]),
    FILTER(
        ALL(your_table_name),
        your_table_name[customer name] = current_row_customer
            && your_table_name[quarter end date] < current_row_quarter_end_date
    )
)

RETURN IF(find_customer_previous_quarter > 0,0,1)

Step-2只需将季度末数据和新创建的自定义列新客户添加到您的表中即可。SUM聚合将自动应用于新的自定义列，最终输出如下-

​

​