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
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.
Proud to be a Datanaut!
You could use ALLEXCEPT in your the average of the same measure of all mondays measure.
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.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!