cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HL_YPTO Member
Member

Ratio of a Day Value vs The average of that Weekday

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

2 REPLIES 2
Super User
Super User

Re: Ratio of a Day Value vs The average of that Weekday

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team
Community Support Team

Re: Ratio of a Day Value vs The average of that Weekday

hi, @HL_YPTO

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]))

1.JPG

 

 

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

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,403)