Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dates between giving unexpected response

Good morning, I have a table with a column with continuous dates between today and 2 years ago.    I am trying to use the code below to create a table with time periods. My intent is to create a co...
"DAX"
Date Table
  • tamerj1's avatar
    tamerj1
    2 years ago

    Hi Anonymous 
    Please try

    Date Periods =
ADDCOLUMNS (
    CALENDAR ( TODAY () - 730, TODAY () ),
    "Type",
        IF ( [Date] < TODAY () - 365, "Vendor 2 Year", "Asset 1 Year" )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous 
Please try

Date Periods =
ADDCOLUMNS (
    CALENDAR ( TODAY () - 730, TODAY () ),
    "Type",
        IF ( [Date] < TODAY () - 365, "Vendor 2 Year", "Asset 1 Year" )
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

tamerj1 Thank you for your time in getting this for me. Will this table only hold 2 years worth of dates and each new day, the table will recalculate itself and the last date disappears?

 

Lola

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Anonymous 
    Exactly