Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Have an issue with following.
Can calculate at row level, previous weekly compliance figure for a store as shown below.
The weekly compliance figure in bold below is an average figure
CALCULATE(AVERAGEX('Sales','Sales'[Weekly Compliance])
Previous Weekly compliance defined as below
Solved! Go to Solution.
Very tough without sample 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
If I am reading this correctly, you are looking to calculate your AVERAGEX calculation where your [Week End Date] = the MAX [Week End Date] - 7 days. Knowing that the Total line calculates in the context of ALL, you would therefore be returning your maximum date from that table and the logic would be that you don't have a [Week End Date] that is exactly 7 days less than that.
Very tough without sample 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
If I am reading this correctly, you are looking to calculate your AVERAGEX calculation where your [Week End Date] = the MAX [Week End Date] - 7 days. Knowing that the Total line calculates in the context of ALL, you would therefore be returning your maximum date from that table and the logic would be that you don't have a [Week End Date] that is exactly 7 days less than that.
Thanks for reply and explanation.
Have changed to instead get the value for max date -7 and this will be the constant value which is then compared to the dynamic value of selection and working as expected now.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |