topic Re: Data Date Missing in Power BI in DAX Commands and Tips

Data Date Missing in Power BI

faiqsadiq1 — Mon, 14 Nov 2022 10:12:29 GMT

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

Re: Data Date Missing in Power BI

FreemanZ — Mon, 14 Nov 2022 12:01:50 GMT

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.

Re: Data Date Missing in Power BI

faiqsadiq1 — Mon, 14 Nov 2022 12:18:15 GMT

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

Re: Data Date Missing in Power BI

FreemanZ — Mon, 14 Nov 2022 12:22:51 GMT

Try this,

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

Re: Data Date Missing in Power BI

faiqsadiq1 — Mon, 14 Nov 2022 12:28:31 GMT

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