Forum Discussion

tryingnewtools's avatar
tryingnewtools
Regular Visitor
8 years ago
Solved

Filter firstdate

Hi,

 

I'm trying to get the firstdate() based on a particular column value

 

For example: FIRSTDATE('Prices'[Date], 'Prices'[Food]="Carrots")

 

However, firstdate does not allow filtering like the above.

 

What would be the best way to do this?

 

Thank you.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

     

    Try this.

     

    Column = CALCULATE(FIRSTDATE(Prices[Date]),FILTER(Prices, Prices[Food]="Carrots"))

     

    Thanks
    Raj

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    We probably need to learn more about your data-table and if you are trying to create this as.

     

    A simplified version might be a calculated measure

     

    Food Date
Apples	2018-01-01
Apples	2018-02-01
Apples	2018-03-01
Bananas	2018-01-15
Bananas	2018-01-19
Bananas	2018-01-20
Carrots	2018-03-01
Carrots	2018-03-02
Carrots	2018-03-10
    First Date = FIRSTDATE('Table1'[Date])
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi

     

    Try this.

     

    Column = CALCULATE(FIRSTDATE(Prices[Date]),FILTER(Prices, Prices[Food]="Carrots"))

     

    Thanks
    Raj