Forum Discussion

Paco's avatar
Paco
Frequent Visitor
10 years ago
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 ...
Need Help
Paco's avatar
Paco
Frequent Visitor
10 years ago

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 

    • Paco's avatar
      Paco
      Frequent Visitor
      10 years ago

      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. 

       

       

       

       

      • Sean's avatar
        Sean
        Community Champion
        10 years ago

        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]