cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
seroskij
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 III
Super User III

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
)

 

 

View solution in original post

1 REPLY 1
Super User III
Super User III

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
)

 

 

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors