AR Ageing Grouping

Hi Anonymous ,

Your expected output seems clear but there are some problems that not certain based on your description:

1. In your sample table and measure formula, seems like the column name is not correspoding, for example, where is the [Amount] column if you created a measure name 'Outstanding Amt'
2. How did you create a group table in query editor?
3. In your same table, the due date is basic the same, but in your picture there seems different

Could you please consider share a dummy .pbix file for further discussion? Please remember to replace the sensitive message in your file.

Best Regards,

Yingjie Li