Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create Aging on column shown

Hello All,      I have been asked to create an Aging filter on my Power BI Table.    I have been trying to add columns / create custom columns and tried to follow steps found in other threads but...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Anonymous , In DAX, you can create a new column like

     

    Datediff([Created Date], today(), Day)

     

    In column in Power Query

     

    Duration.Days(DateTime.Date(DateTime.LocalNow()) - DateTime.Date([Created Date]))

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hello,

     

       Thank you for the assistance. The column you provided worked but not for what is required. I need to have the aging of the CreateDate column. This provides me with : A sum / avg / min/max / count / standard deviation / |Variance / Median. When i try to mimic the "Aging" formula i have on another sheet, it does not pop up anything. Please see photos below.

     

    Please let me know if this is possible. 

     

    Best,

     

     

    . 

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello,

 

   Thank you for the assistance. The column you provided worked but not for what is required. I need to have the aging of the CreateDate column. This provides me with : A sum / avg / min/max / count / standard deviation / |Variance / Median. When i try to mimic the "Aging" formula i have on another sheet, it does not pop up anything. Please see photos below.

 

Please let me know if this is possible. 

 

Best,

 

 

.