Data Date Missing in Power BI

[faiqsadiq1]

Full Data PictureDax Measure

Hi ,I hope you would be all fine and great in health.

I have an issue there is date when inventory would be posted in system but due  to logistics issue it comes and posts after 7 days and i have to add it manually ,so i made a dax measure.

dax measure was successfully but facing some of dates missing .Please need support and help in this matter

[FreemanZ]

Shall try this:

Original Date = Forecast[Date] - 7

BTW, DATEADD is a time intelligence function and thus its first argument needs to be a date column from a Date table.

[faiqsadiq1]

 Thankyou @FreemanZ .it got sorted but i dont want 1 january 1990 to be added except date i need all dates to be added .What would be the solution please

[FreemanZ · Accepted solution]

Try this,

Original Date = IF(Forecast[Date]=DATE(1900,1,1), Forecast[Date], Forecast[Date] +7)

[faiqsadiq1]

Dear @FreemanZ ,Thanks alot .It gives alot of confidence to learn and grow when people like you are always ready to help.

God Bless you