show only the first row in a simple table

[zied_ahmed1]

Hello,

I have the list of tasks completed and i need to show only the last one (so the last row ) 

for example in this table I need only to show Construction and the date (first record)

Thanks 

[Stoyan_Terziev]

Hello Zied,

I presume that's a table with dimension 'Task Name' and measure Max(Finish Date).

Go to the dimension and select Limitation -> Fixed Number -> Top -> 1

Make sure to uncheck 'Others'.

I hope that helps!

Kind regards,

S.T.

[zied_ahmed1 · Accepted solution]

this is the solution : 

left join
load Distinct
//Risque_id,
Date(min("date_birthday"),'DD/MM/YYYY') as "TXT Date",
1 as flag

resident Table1;