Datediff, import query, yesterday data versus Today's

[lewgreen]

Hello All,

I am in need of your help. I have a dashboard which is pulling data via import query and I need to find the difference in the ETA yesterday versus today. I do not need the eta today versus yesterday, but rather what the ETA had as the date yesterday.  

For instance, if the query yeterday showed 03/31/21 as the ETA, and then today showed 03/27/21, then I need the new column/measure to show 4 as the incremental difference between the 2 queries. I hope this makes sense. 

 

[Anonymous]

@lewgreen 
This is really confusing, the difference isn't just 1 between today and yesterday. Or do you have additional dax for yesterday and Today? May create and share a sample pbix link to demonstrate your current situation. 

Paul Zheng _ Community Support Team

[Jihwan_Kim]

Hi, @lewgreen 

please try the below DAX measure.

Differenceindays = DATEDIFF ( SELECTEDVALUE ( ETA[TodayETA]),  SELECTEDVALUE(ETA[YesterdayETA]), DAY )

I hope it helped.

Did I answer your question? Mark my post as a solution, this will help others!

[lewgreen]

Hello.

Unfortunately this does not solve the problem at hand. The information all lives in the same column that is updated daily. So I do not have a column for yesterday's ETA. 

[Jihwan_Kim]

Hi, @lewgreen 

Thank you for your feedback.

Do you mean that the updated ETA is shown in the next row?

Or, does the old ETA disappears once the ETA is updated?

[lewgreen]

Hi Jihwan_Kim,

Our dashboard will be refreshed daily from the import query, so the ETA that showed yesterday will be replaced with what the system tells us the ETA is now today. Sometimes it may not change but if that's the case then we'd show 0 in the datediff calculation.