cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MdB
Frequent Visitor

Measure Calculate until last week

I'm trying to get a measure right. 

 

Certain grades are given and I want to see how they progress every week. For that I try to write a measure that has the average of the grade number and filters until the last week.

 

Unfortunately I cannot get a dynamic week date where the measure has the current week minus 1 (so that it shows the average until last week). Hope someone can help out. 

 

test =

calculate(AVERAGE(table[number]),WEEKNUM('Calendar'[Date])-1)
1 ACCEPTED SOLUTION
jppv20
Solution Sage
Solution Sage

Hi @MdB ,

 

First, create a weeknumber column in your calendar table:

WeekNumber = WEEKNUM('Calendar'[Date],2)
 
Then create a measure like this:
test =
var Maxdate = WEEKNUM(TODAY(),2)-1
return
CALCULATE(AVERAGE('Table'[Number]),'Calendar'[WeekNumber]<=Maxdate)
 
If I answered your question, please mark it as a solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
jppv20
Solution Sage
Solution Sage

Hi @MdB ,

 

First, create a weeknumber column in your calendar table:

WeekNumber = WEEKNUM('Calendar'[Date],2)
 
Then create a measure like this:
test =
var Maxdate = WEEKNUM(TODAY(),2)-1
return
CALCULATE(AVERAGE('Table'[Number]),'Calendar'[WeekNumber]<=Maxdate)
 
If I answered your question, please mark it as a solution to help other members find it more quickly.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors