Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
7 years ago
Solved

Card and Date Difference

I am trying to do a card visualization with the difference between the created date and modified date  (in days).   Which formulas do you recommend.  Thank you for your help!
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi jcastr02,

     

    If you want to create date difference, you could try to use measure 

    measure=DATEDIFF(MIN('date diff'[create ]),MIN('date diff'[mofidy]),DAY)

    or create a calculate column

    Column = DATEDIFF('date diff'[create ],'date diff'[mofidy],DAY)

     

    If you want to show all difference in card, I suggest you could use Multi-Row Card  or use Table to show these result.

    In addition , if possible, could you plaesa inform me "Trying to get a Turn around time for these, please"? What did you mean of this?

     

    Best Regards,

    Zoe Zhi

     

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

     

jcastr02's avatar
jcastr02
Post Prodigy
7 years ago

Trying to get a Turn around time for these, please

dax's avatar
dax
Community Support
7 years ago

Hi jcastr02,

 

If you want to create date difference, you could try to use measure 

measure=DATEDIFF(MIN('date diff'[create ]),MIN('date diff'[mofidy]),DAY)

or create a calculate column

Column = DATEDIFF('date diff'[create ],'date diff'[mofidy],DAY)

 

If you want to show all difference in card, I suggest you could use Multi-Row Card  or use Table to show these result.

In addition , if possible, could you plaesa inform me "Trying to get a Turn around time for these, please"? What did you mean of this?

 

Best Regards,

Zoe Zhi

 

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

 

  • jcastr02's avatar
    jcastr02
    Post Prodigy
    7 years ago

    dax 

     

    The above worked! Thank you so much! Now I'm trying to show the average difference in time on a card on visualization.  How can I change it Average vs. the sum (believe that's what is showing)