Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DATEADD doesn't allow duplicates?

Hey Community,

 

I have a question that might be beyond basic but its got me and I can't find anything here or on google. 

 

When I try and use dateadd on a column any duplicate value returned is blank. 

 

I have a column called that is just =TODAY() and when I try and run a dateadd on it I get all blanks.

 

In another small table I put together by hand I only get results on uniqe values. Is this by design or maybe a setting I can change?

 

 

For context, I am simply trying to filter a related table to get a rowcount of just things on that table that happened yesterday. 

Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

     

    By my tests and research, I'm afraid that your scenario is not caused by duplicate date.

     

    Based on this document, which has mentioned that the result table includes only dates that exist in the dates column.

     

     

    For your scenario, you may could create a canlendar table and then use DATEADD function.

     

    Best  Regards,

    Cherry

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

     

    By my tests and research, I'm afraid that your scenario is not caused by duplicate date.

     

    Based on this document, which has mentioned that the result table includes only dates that exist in the dates column.

     

     

    For your scenario, you may could create a canlendar table and then use DATEADD function.

     

    Best  Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      "The result table includes only dates that exist in the dates column." Yeah, I didn't really understand what this meant but it's the cause of the error I am having. So it is working as advertised, just disappointingly so. Thank you for taking the time to review my issue and reply back!