Measure for getting Minimun date from dataset

[ak77]

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 

[vanessafvg]

do you want to hard code for each scenario, can you provide an example of the the correct solution looks like

[audreygerred]

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.