Forum Discussion
Solved
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 ...
If you want to automate this - you'll have to incorporate this in your Calendar Table - read about it here
Thank you very much, I already create a table with the days. I´m new in DAX, which funtcion do I have to use to select the column in which I have the value.
I already have my fomula like this:
DailySales = TOTALMTD(SUM(Sales2016[Total]),Sales2016[Date])/ (I want to know the function to select the column [Labdays] of the current month from the Days table )
I create a table Days with 2 columns
Column 1 [Month] contains the month 1,2,3,4, etc
Column 2 [Labdays] contains laboralbes days example month 1 labdays 25, month 2 labdays 24, etc.