topic How to get Turn-Around-Time (TAT) in dealing with "Blanks" in DAX Commands and Tips

How to get Turn-Around-Time (TAT) in dealing with "Blanks"

Anonymous — Thu, 02 Feb 2023 14:03:57 GMT

Hi Kind People,

I hope you can help me with these. I'm trying to get the TAT of my data.

1. if Date and Time Accomplished is 'Blank', don't get or include the TAT for this

here's the sample data below,

FreemanZ — Thu, 02 Feb 2023 14:15:35 GMT

hi Anonymous

are you expecting something like this:

TAT = VAR _tat =FORMAT( [Date and Time Accomplished] - [Date and Time Received], "h:m:s") RETURN IF( [Date and Time Accomplished]<>BLANK(), _tat )

Anonymous — Thu, 02 Feb 2023 14:23:16 GMT

Yeyyy!! This works FreemanZ! thank you very much, God bless!