Apply same Month Target to calculate Actual daily achievement rate

[VuongLM93]

Dear all,

I have researched on this forum but have not found an exactly similar answer,

What I have is a monhtly Target for each distributor, product and month,

On a weekly basis I want to cehck if the actual inventory is matching with the target of the month, by SKU and Distributor,

How do I match the month target to distributor / sku like the table below?

(example if a date falls within April -> then target of every day with be the April target)

Thanks so much for your time and support

A data set sample is inthe link below:

https://drive.google.com/open?id=1C1mFEY9woeijiYP-1l_AeoxpVQTror-1

[jdbuchanan71 · Accepted solution]

Hello @VuongLM93 

Once you have your actuals and targets loaded into the model you can use some DAX to create bridge tables (SKU's, Distributors, and YearMonths).  I also added a YearMonthKey to the targets table so it can be joined to a date table.  You end up with something like this.  That YearMonths table in the middle is what joins the dates to the targets.

I have uploaded my sample .pbix file here: Distributors.pbix

This model and a couple measure let you get to the view in your file: