How to get Max of date in case of multiple values

[Kish1999]

Hello All,

I have a situation in which some tasks are having multiple update dates and the update date for some tasks are blank. I wish to get the blank date for the ones that are blank but have to get the max date for the ones where multiple update are present.

Example:

Taskname	Update date
A	20-08-2022
A	24-08-2022
B
C	21-08-2022
C	22-08-2022
D	23-08-2022
Expected Output
Taskname	Update date
A	24-08-2022
B
C	22-08-2022
D	23-08-2022

Can someone please help me write a measure for this.

[Anonymous · Accepted solution]

Hi @Kish1999 ,

According to your description, you want to display the maximum date of each “Taskname”(The empty date should also be displayed in the visual). Right?

When the measure returns BLANK() , the visual object will be filtered by default, but we can solve this problem by creating a new index column in Power Query Editor.

Here are the steps you can follow：

(1)We can put [Taskname] and [Update date] field in the visual. We can also configure the  Format of [Taskname] field what you want.

(2)We can select “Latest” for the [Update date] field to display the maximum date in this “Taskname”.

(3)Then we can select “Show items with no data” in [Taskname] field to display the taskname who has no latest date.

(4)If you don’t want to have “Total” in visual, you can close it in Format Pane.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Kish1999 , use this measure with Taskname in visual

maxx(filter(Table, not(isblank(Table[updateDate])) ), Table[updateDate])

[Kish1999]

Hello @amitchandak ,

This measure does give me the max date but it does not return  the value where the value is blank. In the above case, it does not return the task B.