Forum Discussion
prasadhebbar315
Advocate I
Advocate IDynamic Aging Calculation
Hello everyone, I am trying to calculate aging of status dynamically based on current date and first date of occurence. In the below example, the first 3 cols are available in the source data an...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhg7-ZkuSfG9VrW3a?e=CMtTvs
prasadhebbar315Advocate I
Advocate IAhmedx Thanks for the solution. This solution works now but if the updated date is not present for 02.03.2023 and it is available on 03.03.2023, your calculation is skipping the day and assinging values based on rankx. In the below example: ML_Updated_Date is missing for 02.03.2023. Ideally status aging should be 2 for 02.03.2034 and 3 for 03.03.2023.