Noob help: week value, rolling gauge, and KPI

[jansenuy]

I need to create a measure with a rolling (moving) target based on the week. For example:

Weekly sales target is USD 5000 and it has to total to 5000*52 at the end of the year. Using a guage (because I do not know how to use the KPI ), the maximum value should be higher every week 5000 + 5000 + ... so on per week. This way, we could see how much is our rolling sales gap as we progress in the year.

Is there like a variable for current week number that is automated so I could just use

Rolling Target = var*5000

lol I'm just  looking for a simple way to do this.

Also, why is target value smaller than maximum value when I put my measure? Sidenote: can you also teach me KPI? 😞

Thanks in advance. I'm such a noob.

[Eric_Zhang]

---

@jansenuy wrote:

I need to create a measure with a rolling (moving) target based on the week. For example:

Weekly sales target is USD 5000 and it has to total to 5000*52 at the end of the year. Using a guage (because I do not know how to use the KPI ), the maximum value should be higher every week 5000 + 5000 + ... so on per week. This way, we could see how much is our rolling sales gap as we progress in the year.

Is there like a variable for current week number that is automated so I could just use

Rolling Target = var*5000

lol I'm just  looking for a simple way to do this.

Also, why is target value smaller than maximum value when I put my measure? Sidenote: can you also teach me KPI? 😞

Thanks in advance. I'm such a noob.

---

@jansenuy

You can try

Rolling Target = WEEKNUM(TODAY())*5000

To get further suggestion, please post some sample data(for time saving , please post it in plain text or a file sharing link) and expected output.

[jansenuy]

Thanks! That worked. But, what if I want to filter data to last week?

Is this correct?

FILTER('Master Data','Master Data'[Week]=(WEEKNUM(TODAY())-1))

But my chart is displaying an error.

[Eric_Zhang]

---

@jansenuy wrote:

Thanks! That worked. But, what if I want to filter data to last week?

Is this correct?

FILTER('Master Data','Master Data'[Week]=(WEEKNUM(TODAY())-1))

But my chart is displaying an error.

---

@jansenuy

What is the exact error message? the filter looks correct.