使用Power Bi中的dax计算多个日期之间的平均天数 [英] Calculate Average Number of Days Between Multiple Dates with dax in power bi

问题描述

假设我有以下数据框.我想使用Power Bi中的Dax来计算特定帐户所有活动之间的平均天数

Let's say I have the following data frame. I want to calculate the average number of days between all the activities for a particular account using Dax in power bi

说我有这个:

我想要这样的理想结果

I want a desired result like this

如何在Power BI中使用DAX做到这一点

How do I achieve this using DAX in power BI

推荐答案

假定表中的数据与图片中的数据相同，请创建一个计算列，如下所示:

Assuming you have the data in a table as in your picture, create a calculated column like this:

AvgerageDaysInbetween = 
var thisCustomer = [Customer]
var temp = 
SUMX(
    FILTER(
        SUMMARIZE(
            'Table';
            [Customer];
            "avg";  
                DIVIDE(
                    DATEDIFF(MIN('Table'[DateOfOrder]); MAX('Table'[DateOfOrder]); DAY);
                    DISTINCTCOUNT('Table'[DateOfOrder])-1;
                    0
            )
        );
        [Customer] = thisCustomer
    );
    [avg]
)
return
temp

结果表:

这篇关于使用Power Bi中的dax计算多个日期之间的平均天数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！