Forum Discussion
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!
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.
4 Replies
Trying to get a Turn around time for these, please
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.
