Forum Discussion

lsalves's avatar
lsalves
New Member
9 years ago

DAX FUNCTION DAY's

Has some dax function to filter dates as follows for 2 departments:
For the X department I need to filter dates before or the same as today!
For Y department I need to filter dates before or equal to today plus 2 days, excluding Saturday / Sunday for both situations.

Need Help

2 Replies

  • DoubleJ's avatar
    DoubleJ
    Solution Supplier
    9 years ago

    Hi

     

    I made a small sample with a calendar table containing dates from 2017-03-20 until 2017-04-06.


    I then added a few columns:

     

    Returns 1 if date is before or the same as today; otherwise 0

    IsInPast = IF('Calendar'[Date].[Date] <= TODAY(),1,0)

     

     Calculates the day of week:

    DayOfWeek = WEEKDAY('Calendar'[Date])

    Returns 1 if date is before or equal to today plus 2 days; otherwise 0

    IsBeforeEqualDayAfterTomorrow = IF(DATEADD('Calendar'[Date].[Date],-2;DAY) <= TODAY(),1,0)

     

    Returns 1 if date is before or equal to today plus 2 days AND is not Saturday or Sunday; otherwise 0

    IsBeforeEqualDayAfterTomorrow2 = IF(
     DATEADD('Calendar'[Date].[Date],-2,DAY) <= TODAY() 
     && 'Calendar'[DayOfWeek] <> 7 
     && 'Calendar'[DayOfWeek] <> 1,1,0)

     

    At the time of writing it is March 28, resulting in this table:

     

     

    You can now use these columns for slicers or your visual filters.

     

    Hope this helps

    JJ

     

     

     

     

     

     

    • lsalves's avatar
      lsalves
      New Member
      9 years ago

      Good suggestion, but I want the result using the CALCULATE / FILTER or other functions, however I am not hitting