Forum Discussion

Hepworthnot's avatar
Hepworthnot
Frequent Visitor
4 years ago
Solved

Dates in column not showing when apply DateAdd function

Hi,   I am trying to add either 0 or 1 days to a date depending on the content of the column called Offset.   Here is the formula:   NewColumn = DATEADD('TableName'[DateUTC],[Offset],day)   ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Hepworthnot ,

    According to the offical document, The following formula calculates dates that are one day before the dates in the current context.

    If you want display every value. you could try it.

    NewColumn = 
[DateUTC]+[Offset]

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
4 years ago

yes but without seeing the data its hard to understand whats going.  sharing is best 🙂  also with your expected result.

Hepworthnot's avatar
Hepworthnot
Frequent Visitor
4 years ago

Hi,

 

Does this help? It appears whenever Offset is '0' there is no problem. When it is '1' sometimes it works, sometimes it doesn't.

 

Thanks

 

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    4 years ago

    what does your data model look like?   so what is this table linked too?  do you have a date table?  also if you changed all the offsets to 0 it works fine?  if you try changing it to 2, does it also  not work and do the same rows fail? 

    • Hepworthnot's avatar
      Hepworthnot
      Frequent Visitor
      4 years ago
      vanessafvg wrote:

      what does your data model look like?  

      Not sure I know enough about Power BI to answer that

       

      vanessafvg wrote:

      so what is this table linked too? 

       

      The data is read from a sharepoint list

       

      vanessafvg wrote:

      do you have a date table? 

      Yes

       

      vanessafvg wrote:

      also if you changed all the offsets to 0 it works fine?

       

      Correct

       

      vanessafvg wrote:

       if you try changing it to 2, does it also  not work and do the same rows fail? 

      If I change it to 2 different dates fail