cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## PowerBI Visual with slicer - Averages

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

Super User

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-...
Please show the expected outcome based on the sample data you provided.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors