cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## DATE

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

1 ACCEPTED SOLUTION
Super User

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 👍

3 REPLIES 3

Is there any measure to do this?

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

Super User

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 👍

Super User

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 👍