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 column where dates from today to 1 year ago are given a label, and dates from 1 year ago to 2 years, are given another label.

 

My code returns a blank table.

 

Can someone point me in the right direction on how to fix this?

 

Date Periods =
UNION(
    ADDCOLUMNS(
        DATESBETWEEN(MyDate[Date],TODAY(),TODAY()-365),
        "Type", "Asset 1 Year"
    ),
    ADDCOLUMNS(
        DATESBETWEEN(MyDate[Date],TODAY()-366,TODAY()-731),
        "Type", "Vendor 2 Year"
    )
)
 
I look forward to hearing back from you.
"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" )
)

5 Replies

  • tamerj1's avatar
    tamerj1
    Community 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

  • BeaBF's avatar
    BeaBF
    Super User
    2 years ago

    Anonymous Hi!

    Try with:
    Date Periods =
    UNION(
    ADDCOLUMNS(
    FILTER(MyDate, MyDate[Date] >= TODAY() && MyDate[Date] < TODAY() - 365),
    "Type", "Asset 1 Year"
    ),
    ADDCOLUMNS(
    FILTER(MyDate, MyDate[Date] >= TODAY() - 365 && MyDate[Date] < TODAY() - 730),
    "Type", "Vendor 2 Year"
    )
    )

     

    BBF

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      BeaBF 

      Thank you for the response, once again I get a blank table.

       

      here is the code for my date table if that helps, it is just dates, unsummarized, formatted in DD/MM/YYYY (Short Date)

       

      MyDate =
      CALENDAR(
          min(Historic1[Date]),
          MAX(Historic1[Date])
      )
      Ive done similar things before but using previousqtr or previous month in place of the datesinbetween, but this seems to not work. I apprecaite the response, thank you
       
      Lola