topic Re: Min Date selected in DAX Commands and Tips

Min Date selected

MagikJukas — Wed, 03 Jul 2024 14:02:11 GMT

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

Re: Min Date selected

Anonymous — Thu, 04 Jul 2024 02:02:35 GMT

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.

Re: Min Date selected

MagikJukas — Thu, 04 Jul 2024 06:31:12 GMT

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...

Re: Min Date selected

Anonymous — Thu, 04 Jul 2024 06:45:08 GMT

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.