Card and Date Difference

[jcastr02]

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!

[jcastr02]

[jcastr02]

Trying to get a Turn around time for these, please

[dax · Accepted solution]

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]

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