Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
User | Count |
---|---|
70 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |