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/...
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
)

     

     

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
)