Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Display Last Month Sales in KPI box

hi all,   I am looking for 3 simple calculations including instructions on how to display them in a KPI box.   1. Last month revenue 2. Avg. last 3 months revenue 3. Avg. launch-to-date revenue...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-frfei-msft,

 

Thanks for your reply.

 

I have been trying to replicate your formula using my tables, unfortunately there is some syntax error.

 

Please see attached pictures.

 

I noticed a difference, I have repeating same dates and you only have 1 date per X amount of sale.

 

Could that cause the problems?

 

 

 

 

 

 

 

best regards