Forum Discussion

Figueiredo_Luis's avatar
Figueiredo_Luis
Frequent Visitor
3 years ago

Calculate sales %

Good day all - please I need a support on calculation of [Sale] where I have two column, one is the [DailyTarget_new] and another is the [Actual Sales], the idea is to have it on a daily basis and no...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Figueiredo_Luis 

 

Can you provide more sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Figueiredo_Luis's avatar
Figueiredo_Luis
Frequent Visitor
3 years ago

Hi v-zhangti ,

 

Please see attached the visualization I want to get. I highlighted the outliers results which in PBI returns with (infinity) answer.

Below is the dataset:

 

Regards,

Figueiredo