Forum Discussion
Post PatronMeasure for getting Minimun date from dataset
Hi All,
I need a help for a measure
I have client code , product and DateFrom columns in a dataset
and one client can have multiple products (one to many) for a day
i need a measure to get the MinDate for a product that was available for a particular client
For Ex:
Min (Date From ) for product a for client 1
Min (Date From ) for product b for client 1
Min (Date From ) for product a for client 1
Min (Date From ) for product b1 for client 2
Min (Date From ) for product c for client 2
Please help
and so on
2 Replies
- audreygerred
Super User
Hi! You can use the MIN function for DAx: MIN function (DAX) - DAX | Microsoft Learn
In your example, you could set up a table or matrix that has your product field, your client field, and the measure for MIN date. This will show you the earliest date available for whatever combination of product and client there is.
- vanessafvg
Community Champion
do you want to hard code for each scenario, can you provide an example of the the correct solution looks like
