Forum Discussion

Fidzi8's avatar
Fidzi8
Icon for Helper V rankHelper V
6 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
Fidzi8's avatar
Fidzi8
Icon for Helper V rankHelper V
6 years ago

amitchandak, 
I couldn´t use second part your formula 😕

 

I adjusted your formula but does not work 😕

Thank you
Ondřej

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Fidzi8 , formatted

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

  • Fidzi8's avatar
    Fidzi8
    Icon for Helper V rankHelper V
    6 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
      Icon for Super User rankSuper User
      6 years ago

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