Re: Specific Date range for projects

Anonymous · ‎02-02-2021

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 example, Project 101 may be changing a bag type and Project 102 may be changing labels. Each project starts a different day and runs for 52 weeks. so one project may be 3/1/2020-3/1/2021 and the other will be 6/2/2020-6/2/2020.

What I need to be able to do is associate the Project ID with its product SAP and then have it only pull that project during the 52 weeks that the project is running, and anything outside of that specific range to be 0 or blank. But I have only been able to filter using the date filter, but i need it to filter specifically to the Project ID itself since they all have different savings goals and date ranges.

Thank you !!!!

dedelman_clng · ‎02-04-2021

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 · ‎02-04-2021

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.