I have a pivot table as in the picture below, but when I add the DateID , the days of the month appear in the table for each value. I only want for the first measure (No. of Hours Filled) to have the days of the month, otherwise only the values for each measure. (No. of Available LaborHours, No. of Available Hours VE, No. of WorkedHours, No. of VacationHours, etc.)
Hi, may you copy/paste your modelisation please ? If I undestrand well your need, you have to link just the facts [No. of Hours filled] to your calendar, not the other measures.
