Measure for Minimum Weekly Average

Question

I am trying to calculate the Minimum of a measure I have "Average Loading Time." Essentially, each week I look at the Average from the previous week but I would like to see the record minimum over the course of the data set. The error I am getting is because the data set has a few null loading times signifying we didn't pick up from them which we want to see also.&nbsp;So I need my Measure to calculate the minimum of AVG_LOADING while also ignoring the null values.&nbsp;&nbsp;I have tried two combos of this&nbsp;Minimum Loading 2 = CALCULATE(FILTER('Orders','Orders'[AVG_LOADING]&gt;1),Min([AVG_LOADING]),ALL('CALENDAR'[REPORT_DATE]))&nbsp;Minimum Loading 2= CALCULATE(average(min('Orders'[Loading_time])),ALL('CALENDAR'[REPORT_DATE]))

amitchandak · Answer

Anonymous , I do see any week code here 
&nbsp;
refer if my blog or video can help
Power BI — Week on Week and WTD https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123https://www.youtube.com/watch?v=pnAesWxYgJ8

anonymous · Answer

So the filters are set up on the page to view week_end_date. So Average Loading will pull&nbsp;

Forum Discussion

Measure for Minimum Weekly Average

2 Replies

Related content

DAX Measure for Ranking the valid rows and calculating the average rating

Rolling 12M Average measure

Average of minimum/maximum

Average of measure

Weighted Average Measure