I have Two tables (A And B) both having key which is used to establish relation among them. and Table A having invoice date as shown below
And Table B having From date and Two date as shown below
I need Customer Name from Table B to Table A using key for those where Invoice Date lies between From date & To Date "
Go to Solution.
How about this?
Customer Name =
VAR BetweenDates =
'Table A'[Invoice Date]
>= RELATED ( 'Table B'[From Date] )
&& 'Table A'[Invoice Date]
<= RELATED ( 'Table B'[To Date] )
RELATED ( 'Table B'[Customer Name] )
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.