Solved: MAX date by group – Microsoft Power BI Community

Hi Paul,

Thanks for your response but its not working. Let me explain here again what exactly I have.

Here is the table I do have currently (this is an example as i can’t share data due to privacy);

As you can see above there are multiple layer here up to 3 but in original table there 8 levels.

Now here i would like to calculate no of days between Current date and max of Date column at each level.

so for example, for level 1 which at ID column I would like to see the result like this;

Now same goes to Level 2 which is ACTIVITY column in this example so the result should be like this;

And for Level 3 which Sub-Activity in this example should look like this;

However, at lowest 3-4 levels i am getting what is expected but at top level i am getting like this;

Here you can see days are multiplied depending on how many sub activities there.

So at top level its not working but at low level its working.

Thanks