• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

POWER BI What If with date parameter and selection condition

Marcelo Machado

New Member
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.
66739

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:
66741

Below you can find my POWER BI Page, with Extract Date already as a slicer.
66742
 
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.
 
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.
 

Attachments

  • data_table.zip
    22 bytes · Views: 2
Back
Top