Forum Discussion

dhandapani's avatar
dhandapani
Frequent Visitor
4 years ago
Solved

Query to Conditioned aging calculation

Hello All, I'm very much new to Power BI. I have a complicated item to deal with.   I have a data with dates in mutiple cloumns. I need to calculate the aging based upon following conditions.   1...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi dhandapani ,

     

    When you say 'aging' I'm assuming you mean days between the target date and today. If so, then try this as a new custom column:

    let
  Date.Today = Date.From(DateTime.LocalNow())
in
if [PO Date] <> null then Duration.Days(Date.Today - [PO Date])
else if [Delivery Date] <> null then Duration.Days(Date.Today - [Delivery Date])
else if [Ex Date] <> null then Duration.Days(Date.Today - [Ex Date])
else // your escape value if no condition is true e.g. null, or "Error" etc.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi dhandapani ,

 

When you say 'aging' I'm assuming you mean days between the target date and today. If so, then try this as a new custom column:

let
  Date.Today = Date.From(DateTime.LocalNow())
in
if [PO Date] <> null then Duration.Days(Date.Today - [PO Date])
else if [Delivery Date] <> null then Duration.Days(Date.Today - [Delivery Date])
else if [Ex Date] <> null then Duration.Days(Date.Today - [Ex Date])
else // your escape value if no condition is true e.g. null, or "Error" etc.

 

Pete