Calculating Daily Sales Goals

[Anonymous]

Our corporate sales goals are determined monthly based on number of business days in the month.  I would like to add a goal table to my model that extrapolates this to a daily goal number.  I have a date table already in my model that contains a field for working or non-working days.  Here's what I would like to do:

• Divide the monthly goal by the number of working days in a month and enter that into the daily sales goal.
• Enter a value of 0 into the daily sales goal for non-working days

I'm relatively new to DAX, but haven't found an answer that accomplishes this so far.  Thanks in advance for your help.

[Anonymous]

Share some sample data and expected output

[Anonymous]

Here is what the Excel spreadsheet showing goals looks like that I received (I modified the date columns to make it easier to link to my model for testing while I found a solution):

The table I'd like to create would end up looking like this (total monthly goal is divided by total of "working" days in a month):

The end goal is that I can create a cumulative total and measure performance to date.