Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
I'm relatively new to DAX, but haven't found an answer that accomplishes this so far. Thanks in advance for your help.
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.