Need to show "Latest Date" text value in place of max date row in date column(this data type is date

[Basava]

Hi team,

I have date column in my table, in that date column i need to show "Latest date" text in place of max date row....

I have used calculated column with below dax....

Column=

IF('table'[date]=MAX('table'[date]),      "Latest_date",FORMAT('table'[date],"MM/DD/YYYY")

But it is taking data type as text....

When i used this column in slicer i am not getting exact values

• Requirment is, if i select latest date in slicer that should not be changed when data will be added
• Example: i have data from jan1 to jan20, in date column jan20 should show as "Latest date",,this column should use in slicer,,,,if user select "latest date" that should be like that...
• In future if jan 21 data will added,jan21 should show as "Latest date",,
• In slicer by default jan21 should show as "latest date" without selecting by user it should change dynamically when new date added
  • Please help me on this

[amitchandak]

@Basava , A column can not take slicer value. So max/latest selected date in a measure is  

Max = maxx(allselected(Table) , Table[Date])

This can be used by measures for filtering

In table column  you can only have static one for selection

example 

if([Date] = Max(Table[Date]), "Latest", [Date] & "")

In this case you can save slicer on Latest

[Basava]

Hi,

In this case i have used calculated column with the help of below dax

If(table[date]=max(table[date]),"latest",[date]))

But it is showing data type as text,

I have used this in slicer and selected "latest" and data is not filtering correctly

If i used date colunmn in slicer, it is giving correct results......

Here my concern is using calculated column in slicer is correct or not if useing calculated column in slicer is correct means how can we create......

I have several measures used in report with the help of "table" date column and filtering with calculated column is not giving proper output