MIN Value

[Fidzi8]

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

[amitchandak]

@Fidzi8 , you need [CostP] the Min or You can use a formula in place of that

Without considering filter

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

filter are considered

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

[Fidzi8]

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

I adjusted your formula but does not work 😕

Thank you
Ondřej

[amitchandak]

@Fidzi8 , formatted

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

[Fidzi8]

@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

[Greg_Deckler]

@Fidzi8 Is that a timestamp of some sort? Any idea what it represents/what system. Is it unix time? I have a converter for that if so. https://community.powerbi.com/t5/Quick-Measures-Gallery/Unix2UTC-and-UTC2Unix/m-p/620012#M292 Otherwise would need to know reference date.

Otherwise, I'm not sure I fully understand your data or what you are trying to accomplish. Please post sample data and expected output. Thanks.

[amitchandak]

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