Forum Discussion
Calculating Daily Sales Goals
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.
2 Replies
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.