Hello Naveen,

Thanks for the quick response. Indeed I see there is more clarification on the quesiton needed.

Thanks for the link. I will check it now.

Here is what I understood in the mean time.

I need to add an additional datasource giving a daly calender. As this is not provided in the original data. Where there is only a date when there is also a sale.

This then leads to the following view which differs from the first I sent:

Here you see that

week 1 has 5 days and

week 2 has 7 days.

So the average should be

for week 1: 10.000/5 =2000

for week 2: 71.000/7 = 10.142,9

At the end I would like on top have a table that provides me this, i.e. the weekly averages

Hello,

I tried AVG(ZN([Fieldnm004]))

however this doesn't do anything as this seems to effect the data level and not on the table. As Pointed out on the data level there is only a date where there is a sales. so there is no NULL to replace. The NULL is only displayed when adding a calender file with all days of the year so that also days with no sales are displayed in the table.

So I tried

WINDOW_AVG(ZN([Fieldnm004]))

however here i get the message that "ALL FIELDS HAVE TO BE AGGREGATES OR CONSTANTS"

I guess that's opening another problem,,,

Hello Emmanuel,

thanks for this.

Can you explain what do you mean with "you would have to extract your data source" ?

Does this mean I export the data into MS Access (here it gives me only MS access as an option)  and then reconnet to this DB file  to do the LOD calculation?

Cheers,

Philipp

Hello Emmanuel,

THANKS A LOT !

Amazing how quick this could be solved.

smal remark I changed the formula to

{FIXED [Material],DATEPART('week', [Lieferdatum]):SUM([Fieldnm004])}/5

Cheers to you and the team!