Ratio of a Day Value vs The average of that Weekday

[Anonymous]

Hello,

I've been scanning quite some sample but just can't find (or can't see :-)) what i'm looking for.

I would rate a Value for a given date vs the averga of all dates that have the same weekday.

So if the Date is a monday, rate the measure vs the average of the same measure of all mondays

Kind regards, Harry

[v-lili6-msft]

hi, @Anonymous

You could use ALLEXCEPT in your the average of the same measure of all mondays measure.

For example:

Measure 4 = CALCULATE(AVERAGE(Table1[Qty]))

Measure 5 = CALCULATE(AVERAGE(Table1[Qty]),ALLEXCEPT(Table1,Table1[day]))

If not your case, please share some data sample and expected output. Do mask sensitive data before uploading.

Best Regards,

Lin

[Greg_Deckler]

Well, it's going to depend on your data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But, that being said, you probably will need to use an ALL or ALLEXCEPT with this.