aging
3 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.Solved862Views0likes1Comment
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!Solved3KViews0likes6CommentsDax 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)Solved1.7KViews0likes5Comments