Data is not showing in a column in Power BI.

[mhoff]

Hi 🙂
Can anyone help me why all my data is not showing in Power BI?

I have added a new coloum named "LCI 2" with the following formula: 

LCI 2 = DATEADD('TMI (Index)'[Comm pkg.Planned startup];-84;DAY)

But the results are not showing in all the cells in this column. Does any one now why?

I understand why its blank in cells that are blank, but i dont understand it where i already have a date.

Thank you in advance. 

Best regards

Marte

[Anonymous · Accepted solution]

Hi mhoff,

"The result table includes only dates that exist in the dates column"... [Comm pkg.Planned startup] in your case.

See Function explanation.

https://docs.microsoft.com/es-es/dax/dateadd-function-dax

[v-piga-msft · Accepted solution]

Hi @mhoff,

The reply of Miltinho should be useful.

In addition, if you want to show the date of the 84 days before the 'TMI (Index)'[Comm pkg.Planned startup], you could create another calendar table with CALENDARAUTO fucntion or CALENDAR function, then create the relationship with the tables.

Then you could create the calculated column with the formula below.

Column = DATEADD('calendar'[Date],-2,DAY)

Here is my test example.

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[Anonymous · Accepted solution]

Hi mhoff,

"The result table includes only dates that exist in the dates column"... [Comm pkg.Planned startup] in your case.

See Function explanation.

https://docs.microsoft.com/es-es/dax/dateadd-function-dax