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