cancel
Showing results for
Did you mean:
Helper II

How to connect Minif between two data sources

Hello - I have the following Excel formula that I need to convert into Dax.

=MINIFS(T:T,P:P,B9)

T - Contract date

P - Account name (may have multiple instances)

B9 - account name in a different source

I have tried computing as a column or a measure with Lookupvalues or Calculate without any luck.

Thank you!

1 ACCEPTED SOLUTION
Super User

Hi,

To your matrix visual, drag the Account Name from the Service 4 table.  Write this measure

Min date = min('Table3'[Contract effective date])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
4 REPLIES 4
Community Support

Hi, @amiller5

I briefly simulated some data that I hope fits your situation.

``````Column =
CALCULATE (
MIN ( 'Service 3'[Contract date] ),
FILTER ( 'Service 3', [Account name] = EARLIER ( 'Service 4'[Account name] ) )
)
``````

Service 3:

Service 4:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper II

Here is an example of the data: And i would most likely show it in a matrix, but more importantly I need to cacluate the age of effective date against (Today)date in another measure.

Super User

Hi,

To your matrix visual, drag the Account Name from the Service 4 table.  Write this measure

Min date = min('Table3'[Contract effective date])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

@amiller5 you'd better post a sample of your data table and how you'll be showing your data to the users, in order to help you out.

For example; whether you show in a matrix visual, post how you`d like to show...

Announcements

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

Power BI March 2023 Update

Find out more about the March 2023 update.

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors