Forum Discussion
Rolling 4 Week Average
Hello. I am pretty new to Power BI. I am creating some metrics for our payables department, and one of them is to calculate or measure the average number of invoices posted by each person. The average needs to be a 4 week rolling average. Here are some sample data. Can someone help? Thank you!
Posting Date Invoice No. User ID
10/2/2017 PPI142519 Person A
10/2/2017 PPI142533 Person A
10/3/2017 PPI142561 Person A
10/3/2017 PPI142618 Person A
10/3/2017 PPI142675 Person B
10/3/2017 PPI142534 Person A
10/3/2017 PPI142535 Person A
10/4/2017 PPI142537 Person A
10/4/2017 PPI142620 Person A
10/4/2017 PPI142622 Person B
10/4/2017 PPI142571 Person C
10/4/2017 PPI142358 Person C
10/5/2017 PPI142523 Person C
10/5/2017 PPI142536 Person B
10/5/2017 PPI142538 Person A
10/5/2017 PPI142540 Person A
4 Replies
Thanks! I found that out yesterday...turns out I need to update my Power BI. :)
To get more detailed information about new features, see What's new in the latest Power BI Desktop update?.
Hello. I am pretty new to Power BI. I am creating some metrics for our payables department, and one of them is to calculate or measure the average number of invoices posted by each person. The average needs to be a 4 week rolling average. Here are some sample data. Can someone help? Thank you!
Posting Date Invoice No. User ID
10/2/2017 PPI142519 Person A
10/2/2017 PPI142533 Person A
10/3/2017 PPI142561 Person A
10/3/2017 PPI142618 Person A
10/3/2017 PPI142675 Person B
10/3/2017 PPI142534 Person A
10/3/2017 PPI142535 Person A
10/4/2017 PPI142537 Person A
10/4/2017 PPI142620 Person A
10/4/2017 PPI142622 Person B
10/4/2017 PPI142571 Person C
10/4/2017 PPI142358 Person C
10/5/2017 PPI142523 Person C
10/5/2017 PPI142536 Person B
10/5/2017 PPI142538 Person A
10/5/2017 PPI142540 Person A
