topic Re: Create Aging on column shown in DAX Commands and Tips

Create Aging on column shown

Anonymous — Tue, 25 Jun 2024 14:40:03 GMT

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,

Re: Create Aging on column shown

amitchandak — Tue, 25 Jun 2024 15:17:51 GMT

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]))

Re: Create Aging on column shown

Anonymous — Tue, 25 Jun 2024 16:22:02 GMT

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,