First Invoice date for each customer

[gauravnarchal]

I wanted to create a measure to get the First invoice date for each customer.

The measure should return the results from the start date and ignore the filter/visuals.

Below is the table.

[amitchandak]

@gauravnarchal , see if my blog on this can help, check firstnonblankvalue

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

[camargos88 · Accepted solution]

Hi @gauravnarchal ,

You can use something like:

CALCULATE(MIN(TABLE[DATE]), ALLEXCEPT(TABLE, [CUSTOMER NO]))