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
Community 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