Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get Minimum Date per Category based on Minimum Value per Category

Hi,   I need some help for a relative "simple" problem . I have a table with values per date and category. Now I would like to see the minimum value per category and its RELATED minimum date. How...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Both as new columns

     

    Min Value =
    minx(filter(Table, [Category] = earlier([Category])),[Value])


    Min Date =
    minx(filter(Table, [Category] = earlier([Category]) && [Value] = [Min Value]),[Date])

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ;

Please try to create a measure.

Measure = CALCULATE(MIN('Table'[Date]),FILTER(ALL('Table'),[Category]=MAX('Table'[Category])&&[Value]=MAX('Table'[Value])))

If you have two tables, you can change it.

Measure = CALCULATE(MIN('Table'[Date]),FILTER(ALL('Table'),[Category]=MAX('Table'[Category])&&[Value]=MAX('t1'[Value])))

The final output is shown below:


Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.