cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jansenuy Regular Visitor
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 Man Sad), 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 Eric_Zhang
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 Man Sad), 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 Regular Visitor
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 Eric_Zhang
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.

Helpful resources

Announcements
New Kudos Given Badges Coming

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

Power Platform World Tour

Find out where you can attend!

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