aging

4 Topics

DAX Aging bucket for two different Column
Hi all, I have a table that calculate Age days (calculated columns) based on Actual and Planning date. Then based on Selection, I let user view Aging either from Age days by Actual or Planning. Now, come to the Pie chart, how could I set up so that Pie chart legend which is Aging buckets could filter the visual table for record viewing? Could you please advise.
Solved
rdnguyen
3 years ago Place DAX Commands and Tips
862Views
0likes
1Comment
Measure with historical aging data
Hi community, Over the last few days I have been struggling with the following issue: For my company I need to divide the accounts receivable by aging (<30 days, 30-60 days, 60-90 days, 90+ days). So far so good this is an pretty straightforward thing to do in a calculated column. However, I also need the accounts receivable by age from last week in the same table in my report. In this case the calculated column approach doesn’t work anymore and I will have to start working with measures. I got as far as trying to create a measure per age group looking as follows: Open 0-30 = VAR lastday = MIN(CalendarTable[EOWEEK]) RETURN CALCULATE(SUM('AccountMutations'[AR]), DATESINPERIOD('AccountMutations'[Date], lastday-30, lastday, day)) Open 30-60 = VAR lastday = MIN(CalendarTable[EOWEEK]) RETURN CALCULATE(SUM('AccountMutations'[AR]), DATESINPERIOD('AccountMutations'[Date], lastday-60, lastday-30, day)) Etc. Unfortunately, when I put this in a report table per week this seems to not give me the results I want but in stead gives me the overall difference in AR over the past week (ignoring my aging filter on the measure). I have been looking everywhere and found some ideas for dynamic aging with slicers but nowhere a solution to put the aging of this week and last week next to eachother in a report table. Can anyone think of why this does not work and how to fix it? All creative solutions are super welcome!
Solved
Leggies
4 years ago Place DAX Commands and Tips
3KViews
0likes
6Comments
Avarage of opened tickets Aging
Hello All, I am having a difficulty getting average days count in a month depending on number of cases and the age days of a case/ticket. Below is an example just to give some information. if the problem/ticket/case is Opened on Jan 01, 2021, and it was closed on May 15 2021 In the month of Jan Aging(age) of that ticket is 30 days and in Feb it is 58 days (30 +28) and in Mar 89 (58+31) in April (119) (89+ 30) at the end it should show the average of tickets aging in each month. If anyone knows how we can get this, please let me know and thanks for the help in advance
Anonymous
4 years ago Place Report Server
2KViews
0likes
11Comments
Dax Commands with Date vs Days
I am trying to get the Number of Days between two Dates, then if <= 30, I want the Original Amount to show in the New Current Column. If >= 30 AND <=60, then the Original Amount show in the New 31-60 Column. I'm not getting any DAX error using the below info, but it's showing the Original Amount in both Columns. What am I doing wrong? Any help would be appreciated. New Current = IF(DATEDIFF([Invoice Date].[Date], [New Date Paid Off].[Date] <= 30, DAY), Exceptions[Original Amount],0) New 31-60 = IF(DATEDIFF([Invoice Date].[Day] >= 31, [New Date Paid Off].[Day] <= 60,DAY), Exceptions[Original Amount],0)
Solved
ktipton
4 years ago Place DAX Commands and Tips
1.7KViews
0likes
5Comments