Best Visual For Comparing Two Dates

[Anonymous]

I have three columns,

Phsyical Date, Price Approved Date and a caluclated column called Lag that calculates the days between the the dates. I currently have it in a table visual. Is there another visual that I can use to present the data?

[Anonymous]

Hi  @Anonymous ,

You might consider using the following dax:

Measure =
AVERAGEX(
    ALL('Table'),
    DATEDIFF([Physical],[Pricew Approved],DAY))

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, this was not working, it would not let me put DATEDIFF. Please advise. Thank you.

[Anonymous]

@Anonymous  What parts of the process can be looked at to cut down on process times?

As far as an average goes; are you referring to something like this?

 Avg. Lag Time =
DIVIDE ( SUM ( Sheet4[Lag] ), DISTINCTCOUNT ( Sheet4[Physical Date] ) )

[Anonymous]

@Anonymous  What story are you trying to tell? The only option that's jumping out at me at this point is to apply conditional formatting to the Lag column.

[Anonymous]

@bcharger6

Needing to know the days it takes between processes. Trying to cut down on process times to get invoices out to customers faster. Is there a way to take that Lag column and calculate the average number of lag days?