Forum Discussion

amiller5's avatar
amiller5
Icon for Helper II rankHelper II
4 years ago
Solved

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 s...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...