POWER BI What If with date parameter and selection condition

[Marcelo Machado]

Hi, I'm new in POWER BI and need help to create a simulation.

I have a table with demand information. With historical "pictures". In the example below I've extracted a info in day feb 17th, and other picture in feb 20th.


So in each Extract_Date we can have multiples orders for many different materials in many different necessities dates for many different customers.
I need to simulate, for example: "Based on Extract-date feb20th, What happens to my volume if we postpone 30 days the orders for customer C3?"
I don't know how to do that in POWER BI.

Just to make it clear, below a demo:


Below you can find my POWER BI Page, with Extract Date already as a slicer.

 

[Chihiro]

Without sample file with your data model, it's bit hard to help you. At least, upload workbook with sample data table(s) along with explanation of data relationship.

 

[Marcelo Machado]

Hi!

Coping the simulation question:
"Based on Extract-date mar02nd, What happens to my volume of demand if we postpone 30 days all the orders for customer code 6 ?"

Columns:
EXTRACT_DATE - date that all data was extracted from ERP
Customer_Group - self explained
Customer_Code - code of the customer
Material_Code - code of the material ordered by the customer
DEMAND_FROM - region of customer
QUANTITY - self explained
DEMAND_DATE - necessity date of the material ordered

Here is the excel file with table.
I've tried to attach the POWER BI model, but 5MB is not allowed.