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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

     

    Try this.

     

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

     

    Thanks
    Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

Try this.

 

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

 

Thanks
Raj