when my date column meets min date as a variable to display another column?

[Sampathkumar_v]

Hi Folks,

To display another column bases on some condition using date fields?

e.g when by date fields meets min date as a agrument to display region column?

I have wrote this code but still no progress

VAR _SelectedDates =VALUES('Base Data'[DATE_ON])

VAR _MINDate=MINX(_SelectedDates,'Base Data'[DATE_ON])

var DC= IF('Base Data'[DATE_ON]=_MINDate,'Base Data'[Sub Categories],"NA")

return

DC

[amitchandak · Accepted solution]

@Sampathkumar_v , You can not use slicer value in column, Create a measure

if(Min(Date[Date]), calculate(Min(Date[Date]), filter(allselected(Table), [Region] = max(Table[Region]) )) , "Min", "Na")

You can use dynamic segmentation for slicer on a measure

example

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q