Min Date selected

[MagikJukas]

Hello,

I have the following simple table.

When selecting material D and Dates Feb, Mar, Apr, I wish the Measure to show Feb.

regardeless the material selected, I want to display the earliest date selected.

can you advice how to achieve it?

regards

[Anonymous · Accepted solution]

Hi @MagikJukas ,

I create a table as you mentioned.

Then I create a new table.

Table 2 = ADDCOLUMNS(VALUES('Table'[Date]),"Month",FORMAT([Date],"mmm"))

Also I create a measure and get what you want.

Measure = 
VAR _MinDate =
    CALCULATE ( MIN ( 'Table 2'[Date] ), ALLSELECTED ( 'Table 2' ) )
RETURN
    CONCATENATEX ( FILTER ( 'Table 2', 'Table 2'[Date] = _MinDate ), [Month] )

Best Regards

Yilong Zhou

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

[MagikJukas]

thanks for your reply.

I see your strategy, you basically create a new field of dates linked to the dataset.

I was hoping to find simpler solution, like 

Calculate(Min(date),all(material),allselected(date))

 but I really struggle to understand hwo to fix it...

[Anonymous]

Hi @MagikJukas ,

I don't think my approach is difficult, on the contrary, it does what you do and is easy for you to understand.

The solution you mentioned can't be implemented, because in the basic Table, it will change as the Slicer changes. And there are two Slicers in this case, and there is a hierarchical relationship between them, which is not possible to implement with what you would call DAX code.

Best Regards

Yilong Zhou

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