Forum Discussion
gauravnarchal
6 years agoPost Prodigy
First Invoice date for each customer
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.
Hi gauravnarchal ,
You can use something like:
CALCULATE(MIN(TABLE[DATE]), ALLEXCEPT(TABLE, [CUSTOMER NO]))
2 Replies
- camargos88Community Champion
Hi gauravnarchal ,
You can use something like:
CALCULATE(MIN(TABLE[DATE]), ALLEXCEPT(TABLE, [CUSTOMER NO]))
- amitchandakSuper User
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