Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Full Data Picture
Dax 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
Solved! Go to Solution.
Try this,
Original Date = IF(Forecast[Date]=DATE(1900,1,1), Forecast[Date], Forecast[Date] +7)
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.
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
Try this,
Original Date = IF(Forecast[Date]=DATE(1900,1,1), Forecast[Date], Forecast[Date] +7)
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