Forum Discussion

Fidzi8's avatar
Fidzi8
Helper V
5 years ago

MIN Value

Hi, I  need min value 115.   When I filter month June, I see min value 121 - besause Haulier had this month 121.  I need always the same min value of LOG_CODE.   Thank you  Ondřej
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

Fidzi8 , formatted

 minx( filter(all(Table)
                       ,Table[log_code] ="T00265401970"
                       )
       , [CostP])

Fidzi8's avatar
Fidzi8
Helper V
5 years ago

amitchandak ,
I can´t use "T00265401970" because I have a lot of unique codes

I don´t know how use all DATE in this formula

Thank you
Ondřej

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Fidzi8 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.