Forum Discussion
DAX Function
If you want to automate this - you'll have to incorporate this in your Calendar Table - read about it here
Paco Try this... Let me know if it works
Number of Days = DATEDIFF ( STARTOFMONTH(Table1[Date]), ENDOFMONTH(Table1[Date]), DAY)
I really appreciate you quickly answer, I try the function and it's working, theres is only one missing, It's counting Sundays and I don't want to count them.
In Excel the formula WORKDAY.INTL(start_date, days, [weekend], [holidays]) I have to enter 11 inside [holidays] to not to count sundays.
If I use the function Number of Days = DATEDIFF(DATEVALUE("04/01/2016"),TODAY(),DAY)+1 the result is 21 and I need 18 because there are 3 sundays that I don't want to count,
Thank you!! :D
Note: An apology if there is some misspelling but I´m from Mexico :D :S
Sorry in Excel I have to enter 11 in [Weekend]
If you want to automate this - you'll have to incorporate this in your Calendar Table - read about it here
