cancel
Showing results for
Did you mean:
Regular Visitor

## Noob help: week value, rolling gauge, and KPI

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.

3 REPLIES 3
Moderator

## Re: Noob help: week value, rolling gauge, and KPI

@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.

Regular Visitor

## Re: Noob help: week value, rolling gauge, and KPI

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.

Moderator

## Re: Noob help: week value, rolling gauge, and KPI

@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.

Announcements

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,872)