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);

 

Main Table .PNG

 

 

 

 

 

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;

Table.PNG

 

 

 

 

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

Table.PNG

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

Table.PNG

 

 

 

 

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

Tab.PNG

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

Rate this post