DAX for calculating payment on time

[daydream1989]

Hi all, I need to do a calculation which use clearing date minus due date and anything more than 0 is considered as on time payment, and anything less than 0 is considered as late payment. How can i do that? What is the DAX formula for this?

[amitchandak · Accepted solution]

@daydream1989 , You can create a measure like

new column =

var _diff =  datediff([clearing date],[dure Date], day)

return

Switch( True() ,

_diff > = 0, "On Time"

"Late"

)

Or you can create a measure

On time = countrows(filter(Table, datediff([clearing date],[dure Date], day) ) )