Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 =
Solved! Go to Solution.
Hi @Anonymous ,
First, create a weeknumber column in your calendar table:
Hi @Anonymous ,
First, create a weeknumber column in your calendar table: