Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX - Days until Christmas

I'm trying to calculate how many days until Christmas (12/25). I have a fact table that has a date field and a Calendar with a date key.  

 

Example: 

 

Transaction Date   Days until Xmas

12/24/16                 1

12/24/17                 1

12/25/17                 0

12/23/18                 2

etc.

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous 

     

    Try this as calculated column in your table:

     

    Days until Xmas =
DATEDIFF (
    DATE ( YEAR ( Table1[Transaction Date] ), 12, 25 ),
    Table1[Transaction Date],
    DAY
)

     

     

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi Anonymous 

     

    Try this as calculated column in your table:

     

    Days until Xmas =
DATEDIFF (
    DATE ( YEAR ( Table1[Transaction Date] ), 12, 25 ),
    Table1[Transaction Date],
    DAY
)