cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
seroskij Frequent Visitor
Frequent Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: DAX - Days until Christmas

Hi @seroskij 

 

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 1
Super User
Super User

Re: DAX - Days until Christmas

Hi @seroskij 

 

Try this as calculated column in your table:

 

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