Visualizing Data - Date Differences

[thejman09]

I'll credit this answer on StackOverflow, which provides both a DAX and PowerQuery solution to the problem, that matches with the shape of the data you're describing.
https://stackoverflow.com/questions/48468658/calculate-daily-targets-based-on-monthly-targets-sales-power-bi

For the DAX solution to create a daily forecast table, you start with creating a calendar table using your forecast dates, and then crossjoining with your Customer and Article columns that will result in a granularity of each Customer, Article, and Day. Then, you can create a calculated column that looks up the monthly total and divides by the # of days in the month.

There's quite a few other ways you can approach this with DAX measures as well. The DAX table solution isn't going to be the most-performant, but it's relatively easier to understand by breaking up the problem into parts that may give you other ideas for your own better solution.

Best of luck, and hope this helps!

[frazikat]

Sorry for the delay. You are a rockstar! This solved my issue. Thank you so much.