DATE

[Syndicate_Admin]

Good afternoon

I need to calculate the time that has elapsed from 1/01/2023 to today in PowerBi, what work should I do to obtain this calculation.

the idea is to calculate the LEADTime of a Purchase Order.

I appreciate it very much

[Syndicate_Admin]

Is there any measure to do this?

I have column ORDER DATE, and another column TODAY- DATE or Delivery Date.

[DOLEARY85 · Accepted solution]

You can try using values for a measure something like:

Measure = DATEDIFF(VALUES('Table'[ORDER DATE]),VALUES('Table' [TODAY- DATE or Delivery Date]),DAY)

or if you want a calculated column:

Column = DATEDIFF('Table'[ORDER DATE],'Table' [TODAY- DATE or Delivery Date],DAY)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[DOLEARY85]

Hi,

Assuming your date is in a date field, you could create a calculated column with a date diff calc, such as:

Column = DATEDIFF('Table'[Date Field],today(),DAY)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍