To Count Working Days in any Month with DAX

Now | Me

[FourtySeven]

</like> I like jazz.......RETURN
“I like jazz”....
Or something like that.

[FourtySeven]

Thank you.

The problem is, I don’t have a pencil.

(or a calendar)

[FourtySeven]

I don’t see DAX listed there.

Must be an oversight.

</oversight>

SUMMARY(’Oversight’[Oversight1], ‘Return table[Date],[Date],’Order Summary[Order Date], [Date].[Date], 0,True)

[FourtySeven]

Don’t forget M!

[FourtySeven]

Was I not supposed to post this thread?

Was that bad?

</costanza>

[FourtySeven]

I’m guessing that you’re one of the laid off pipeline workers that jumped right into the programmer field. Looks like the transition is going well.

Yes! I figger I should have the oxetane line linked to the CO2 tank in no time...............

(did I fake it enough there? I wonder if Crazy Uncle Joe would hire me)

[FourtySeven]

Yes! Close () of course.

[FourtySeven]

*sigh* Terry Farrell

</dreamy music>

[SamAdams76]

Now if you used Excel, you could use a much simpler formula such as this:

=NETWORKDAYS (start_date, end_date, [holidays])

The holidays part is optional.

[FourtySeven]

*SiGH*

Tell me about it!

I mean that’s ALL a brotha is asking for in DAX ... who thought it was a good idea to remove that function?!

Oh yeah....DAX is all about columns.....yah yeah whatever...unghh