PowerBI Visual with slicer - Averages

mangoman — Mon, 10 Oct 2022 11:49:42 GMT

Hi,

I'm not sure how to approach this problem. I have two tables, a Date table and a Data Table, both are at the end of the question.

I want to create a visualisation with options for:
1. A Date Slicer Start Date (DD/MM/YYYY) - End Date (DD/MM/YYYY)
2. Calculated Value1 - Average of the weekly average weight per carton (7 day) average over date Slicer time period
3. Calculated Value2 - Average of weight per carton over the entire Slicer time period

Formula from Excel:
1. SUM of Weight = (PACK WGHT + JCE WGHT1)
2. Average Carton Weight = SUM of Weight/CARTON QTY

Example 1:
Date Splicer - 01/10/2022 - 10/10/2022 (10 days)
Two values:
1. Average of Weekly Average Weight per Carton of 1 week (7 days from 3/10 - 10/10/2022)

2. 10 day Average of Weight per Carton

Example 2:
Date Splicer 07/08/2022 - 10/10/2022 (64 days)
1. Carton Weight Average of last 9 weeks (truncate from 9 weeks 1 day) average weight ((average of every 7 days from 08/08 to 10/10/2022)/9 weeks)

2. 64 day Average of Weight per Carton

The Date and Data tables are below

Data Table

Date Table

Thanks in advance

Re: PowerBI Visual with slicer - Averages

lbendlin — Fri, 14 Oct 2022 00:04:41 GMT

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic Re: PowerBI Visual with slicer - Averages in Custom Visuals Development Discussion

PowerBI Visual with slicer - Averages

Re: PowerBI Visual with slicer - Averages