Hi,

I have been trying to display a number of working days in a month example below. I am able to calculate sales on working days be taking these steps but can’t figure out a way to display it.

First, Conditional formatting column for working days = if [DayInWeek] = 6 then 2 else if [DayInWeek] = 0 then 2 else 1)

Second, Workdays (measure) = SUM(‘Date’[WorkingDays])

Days Total Sales

January- Working Day 1 $140

January- Working Day 2 $150

January- Working Day 3 $160

Feb- Working Day 1 $130

Feb-Working Day 2 $120

I would appreciate some help.