Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Specific Date range for projects

Hello! I hop my explanation does this justice.    I am doing a Cost Savings Projects analysis.    It is a manufacturing plant, and we are changing aspects of the production to lower cost. For exa...
Date and Time
Date Table
DAX
Filter Multiple Column
power bi
range
dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous - can you share a copy of your pbix with sensitive data remvoed? Your explanation doesn't have enough details in it to see where you went wrong.

 

David

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hey David!! Here are some screen captures that I hope help: 

     

    So Savings Project ID is the generic project and then we have Savings project ID 2 (for projects within that) All of our pertinent data comes from the Numerical Material #, in other words , the product SAP code. This is entered into a daily database as the product moves through manufacturing. I have made measures (in the measures column) that determines how much savings I am making from each project per 10 lbs or case of product. However, as you can seem the projects have a specific start and end date. I have a date table, but I need a DAX or some measure so that it only pulls the savings measure from the project ID start date to end date, otherwise it will pull indefinite amounts of data, because each project may or may not have a different start and end date. Each project runs for 52 weeks.