topic Re: Datediff, import query, yesterday data versus Today's in Desktop

Datediff, import query, yesterday data versus Today's

Anonymous — Mon, 22 Mar 2021 20:55:43 GMT

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.

Re: Datediff, import query, yesterday data versus Today's

Jihwan_Kim — Mon, 22 Mar 2021 23:34:55 GMT

Hi, Anonymous

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!

Re: Datediff, import query, yesterday data versus Today's

Anonymous — Tue, 23 Mar 2021 14:24:19 GMT

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.

Re: Datediff, import query, yesterday data versus Today's

Jihwan_Kim — Tue, 23 Mar 2021 14:32:33 GMT

Hi, Anonymous

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?

Re: Datediff, import query, yesterday data versus Today's

Anonymous — Tue, 23 Mar 2021 15:24:58 GMT

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.

Re: Datediff, import query, yesterday data versus Today's

Anonymous — Thu, 25 Mar 2021 02:50:18 GMT

Anonymous
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