cancel
Showing results for
Did you mean:
Highlighted
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

## Re: DAX - Days until Christmas

Try this as calculated column in your table:

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

Super User III

## Re: DAX - Days until Christmas

Try this as calculated column in your table:

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

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors