Forum Discussion

MagikJukas's avatar
MagikJukas
Resolver III
2 years ago
Solved

Min Date selected

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's avatar
    Anonymous
    2 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      MagikJukas
      Resolver III
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.