Forum Discussion
Paco
10 years agoFrequent Visitor
DAX Function
Hello, I´m trying to get the days from the first day of the month until TODAY (function). In Excel I use WORKDAY.INTL but I don´t know which DAX Function to use or if it´s posible. What I´m ...
- 10 years ago
If you want to automate this - you'll have to incorporate this in your Calendar Table - read about it here
Sean
10 years agoCommunity Champion
Paco I think TotalMTD requires the second part of the formula to point to the calendar/date table
so if your formula is not working => change Sales2016[Date] to CalendarTableName[Date Column]
Paco
10 years agoFrequent Visitor
Thank you very much for your support I already solved it with your help :D