Forum Discussion
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 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,
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]))
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,
.
2 Replies
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]))
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,
.