Create Aging on column shown

[Dklein]

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 im having an hard time. Once i apply a formula and press apply, it removes the whole table and all my visuals show "Fix this".

Please let me know if anyone can help!

Best, 

[amitchandak · Accepted solution]

@Dklein , 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]))

[Dklein · Accepted solution]

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,

. 

[amitchandak · Accepted solution]

@Dklein , 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]))