Combine Date Table?

[bhmiller89]

I have a Date Table that I populated and created a relationship to a table of scheduled requests (SRs) via their start date (not end date).

every SR has an assigned user. Not every assigned user has an SR schecduled for every day of the month. I easily can show a visual of SRs scheduled, but I can't figure out how to show empty (or "free") days. When I use the Date Table date as a column and then the SRs, nothing populates.

[AlexChen]

Hi,

I assume you have a table “requestInfo” table like below.

Firstly, create a calculated column to get the last end date:

Column =
VAR PreID = requestInfo[requestId] - 1
RETURN
(
IF( LOOKUPVALUE( requestInfo[assigned user], requestInfo[requestId], PreID ) <> requestInfo[assigned user], requestInfo[end date],
LOOKUPVALUE( requestInfo[end date], requestInfo[requestId], PreID )
))

Secondly, create another column to calculated free days between SRs:

freeDays = if([start date] < [Column], 0, DATEDIFF([Column], [start date], DAY)-1)

Now, you can create a table to get all free days for users:

Table = CALCULATETABLE(SUMMARIZECOLUMNS(requestInfo[assigned user], "free days", sum(requestInfo[freeDays])))

Best Regards

Alex

[KGrice]

If you take the Date from your Calendar table and use it on a column chart Axis, and use something like an Assigned SRs measure for the Value, you want to show all of the dates, not just the ones that have an Assigned SR on the given date? Click the drop-down for the Date field in the Axis section, then check Show items with no data. All of your dates should show on the axis now.