AP aging Report using DATEDIFF, do not want the formula to round up

[ovanslyke]

Hello,

This is my current formula which I believe is giving me my issue:

Aging = datediff(Append1[Invoice Date(EST)],today(),DAY)

It's that datediff rounds the number up. I do not want it to do this. For example the invoice is aged 90.33 days. I want it to fall into my 75-90 bucket, right now its goig into my 91 +.

What do I need to add to my formula to make it work as I am expecting? Thank you!

[Vvelarde]

@ovanslyke

Hi, try with this:

Column = DIVIDE(DATEDIFF(Table1[Date],TODAY();MINUTE),1440)

[ovanslyke · Accepted solution]

In place of my old formula, I tried as you suggested. This is a copy and paste of what I had in Power BI:

Aging = DIVIDE(DATEDIFF(Append1[Invoice Date(EST)];TODAY();MINUTE);1440)

It came back with a syntax error for this-  ;

Once I changed the ; to a , then it worked for me!

Thanks for the fast reponse!