how to organize data from EXCEL to POWER BI (Logic)

[migueldfr]

Hi folks,

I am doing some basic dashboard in Power BI, the data I have is in excel, but I'd like to find the logic to show in POWER BI or knowhow.

B = 22' STORE SALES

C = 23' STORE SALES

E = AUTOMATICALLY +5% ( C + 5%) 

G = B4/E4

I = RATIO WEIGHT BY PRODUCT 

K = this formula is designed to return twice I4 if the product of I4 and G4 is greater than or equal to twice I4. Otherwise, it returns the product of I4 and G4. The IFERROR function is used to handle any errors that may occur during this evaluation.

I would like to show that in some chart where I can show the real output of sales, +5% change, consecucion and Final result.

I will appreciatte any help.

Thanks in advance

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...