Calculate table with calculate the last date

[jppuam]

Hello, i want to create a calculated table with the client code and the last date that he complains. How can i do this ?

In this example, i should have a table with the following data:

1031 20 May

5789 25 Jun

.....

15490 16 Sep (and so one)

thank you

Joao Rodrigues

[v-yiruan-msft · Accepted solution]

Hi @jppuam ，

You may no need to create a calculated table, just follow the steps in the below screenshot to get the latest complain date.

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[Ashish_Mathur]

Hi,

Drag Client Code to the Table visual and write this measure

=max(Data[Complain Date])

Hope this helps.

[CNENFRNL]

Hi, @jppuam , you may want to try this for a calculated table,

ADDCOLUMNS (
    SUMMARIZE ( 'Table', 'Table'[Cleint code] ),
    "Last Complain Date", CALCULATE ( MAX ( 'Table'[Date] ) )
)

or equally,

SUMMARIZECOLUMNS (
    'Table'[Cleint code],
    "Last Complain Date", MAX ( 'Table'[Date] )
)

[sanalytics]

@jppuam 

Try this below measure for creating calculated table

SUMMARIZE('Table','Table'[Cleint code],"Lastdate",MAX('Table'[Date]))

regards,

sanalytics

if it is your solution please accept it as solution and please like