Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |