Current Rate of Current Week

Question

I am trying to get the current rate from a column but also needs to be pulling from the most current week of the year. Any thoughts or ideas? The year's current week changes every week, so I need to pull the most current week for when I refresh data. I already made the CurrentWk metric and the CRate metric but nee CurrentRate

CurrentWk = CALCULATE(Max('TABLE1'[WkNm]),'TABLE1'[SchoolYear] = "SY20/21")

CRate = DIVIDE(sumx('TABLE1','TABLE1[CumWDs]),'TABLE1'[CumDenominator],"")

This formula isn't working.

CurrentRate = CALCULATE('TABLE1'[CRate], FILTER(ALL('TABLE1'[WkNm]), 'TABLE1'[WkNm] = 'TABLE1'[CurrentWk]))

anonymous · Answer

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

amitchandak · Answer

dwel0120 , Try like 
CurrentRate = CALCULATE('TABLE1'[CRate], FILTER(ALL('TABLE1'), 'TABLE1'[WkNm] = 'TABLE1'[CurrentWk]))
&nbsp;
or better a separate table for week and try like
CurrentRate = CALCULATE('TABLE1'[CRate], FILTER(ALL('Week'), 'Week'[WkNm] = 'TABLE1'[CurrentWk]))
&nbsp;
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/1051123

dwel0120 · Answer

amitchandak&nbsp;Neither solution worked for me. I tried&nbsp;CurrentRate = CALCULATE('TABLE1'[CRate], FILTER(ALL('TABLE1'), 'TABLE1'[WkNm] = 'TABLE1'[CurrentWk])) and it didn't come up with the correct number and then I created a new "Date" table and tried&nbsp;CurrentCWMRate =&nbsp;CALCULATE ('CwmData'[CwmRate],&nbsp; FILTER(ALL('Date'), 'Date'[Week Number] = 'CwmData'[CurrentWk])) and that didn't work either. When I tried the new Date table it came up BLANK.

amitchandak · Answer

dwel0120 ,Can you share sample data and sample output in table format?

dwel0120 · Answer

amitchandak&nbsp;SchoolYearWeekOfWkNmSchoolIDSchoolGroupRegionGradeBandRetentionModelStudentCohortSeasonStartCumAddsCumWDsCumInElWDsCumTransferInCumTransferOutRecordTypeSY18/19Wednesday, November 21, 2018251220CWRHSNew000000DSY18/19Wednesday, March 20, 2019421220CWRHSNew000000DSY18/19Wednesday, July 25, 201881220CWRHSReturning000000DSY19/20Wednesday, October 2, 2019185840CWRMSReturning000000DSY19/20Wednesday, October 23, 2019215840CWRMSReturning000000DSY19/20Wednesday, February 19, 2020385840CWRMSReturning000000DSY19/20Wednesday, September 4, 2019145840CWRMSReturning000000DSY20/21Wednesday, August 19, 2020121007CWRK5Returning000000DSY20/21Wednesday, August 19, 2020121080CWRK5New000000DSY20/21Wednesday, August 19, 2020121080CWRK5Returning000000D&nbsp;DateMonthYearWeek Start dateWeek End dateWeek NumberWeekWeekdayWeekDay NameMonthSort1/1/2005 0:00January200512/27/2004 0:001/2/2005 0:0012005016Sat2005-011/2/2005 0:00January200512/27/2004 0:001/2/2005 0:0012005017Sun2005-013/10/2019 0:00March20193/4/2019 0:003/10/2019 0:00102019107Sun2019-033/11/2019 0:00March20193/11/2019 0:003/17/2019 0:00112019111Mon2019-033/12/2019 0:00March20193/11/2019 0:003/17/2019 0:00112019112Tue2019-035/4/2020 0:00May20205/4/2020 0:005/10/2020 0:00192020191Mon2020-055/5/2020 0:00May20205/4/2020 0:005/10/2020 0:00192020192Tue2020-055/6/2020 0:00May20205/4/2020 0:005/10/2020 0:00192020193Wed2020-055/7/2020 0:00May20205/4/2020 0:005/10/2020 0:00192020194Thu2020-055/8/2020 0:00May20205/4/2020 0:005/10/2020 0:00192020195Fri2020-05&nbsp;

Forum Discussion

Current Rate of Current Week

6 Replies

Related content

Utilization Rate

Currency FX Rates

Exchange Rates - Historical

Keeping a fixed conversion rate while comparing current and previous year

Adding an intererst rate