Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Best Visual For Comparing Two Dates

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?

 

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      @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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

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