Lookup Value with If

Question

Hi All,&nbsp;I have two tables, I am writing a calculated column in table 2 to get the information that if Closed Date of table 2 is greater than equal to the month column of table 1 in that case in the new calculated column it should give as "No" otherwise lookup value from table 2 to get the status of the company code.let me know if anyone can help&nbsp;Table 1:&nbsp;Company CodeCompany NameStatusClosed Date1AVYes&nbsp;2VAYes15/11/20233RKYes&nbsp;4KRYes&nbsp;5ASYes15/11/2023&nbsp;Table 2:Company CodeCompany NameSupplier NrSupplier NameMonthCalculated Coulmn1AV111ABCNov-23&nbsp;2VA111ABCNov-23&nbsp;3RK111ABCNov-23&nbsp;4KR111ABCNov-23&nbsp;5AS111ABCOct-23&nbsp;1AV111ABCOct-23&nbsp;2VA111ABCOct-23&nbsp;3RK111ABCOct-23&nbsp;4KR111ABCOct-23&nbsp;5AS111ABCDec-23&nbsp;1AV111ABCDec-23&nbsp;2VA111ABCDec-23&nbsp;2VA111ABCOct-23&nbsp;2VA111ABCDec-23&nbsp;2VA111ABCDec-23&nbsp;3RK111ABCDec-23&nbsp;3RK111ABCAug-23&nbsp;3RK111ABCAug-23&nbsp;3RK111ABCAug-23&nbsp;5AS111ABCAug-23&nbsp;5AS111ABCAug-23&nbsp;5AS111ABCDec-23&nbsp;5AS111ABCDec-23&nbsp;5AS111ABCAug-23&nbsp;5AS111ABCNov-23&nbsp;2VA111ABCSep-23&nbsp;2VA111ABCSep-23&nbsp;

anonymous · Accepted Answer

Hi&nbsp;cyborgandy&nbsp;,The table data is shown below:Please follow these steps:1. Use the following DAX expression to create a columnColumn = IF(ISBLANK(LOOKUPVALUE(Table1[Closed Date],Table1[Company Code],'Table2'[Company Code])),
"YES",
IF(MONTH(LOOKUPVALUE('Table1'[Closed Date],'Table1'[Company Code],'Table2'[Company Code]))&gt;MONTH('Table2'[Month]) ,
"NO",
"YES"))2. Final output&nbsp;Best Regards,Wenbin ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.&nbsp;

Forum Discussion

Lookup Value with If

1 Reply

Related content

Lookup rank value?

Lookup value

Lookup help

lookup value in another column

Lookup Value From Within Virtual Table

Company Code	Company Name	Status	Closed Date
1	AV	Yes
2	VA	Yes	15/11/2023
3	RK	Yes
4	KR	Yes
5	AS	Yes	15/11/2023

Company Code	Company Name	Supplier Nr	Supplier Name	Month	Calculated Coulmn
1	AV	111	ABC	Nov-23
2	VA	111	ABC	Nov-23
3	RK	111	ABC	Nov-23
4	KR	111	ABC	Nov-23
5	AS	111	ABC	Oct-23
1	AV	111	ABC	Oct-23
2	VA	111	ABC	Oct-23
3	RK	111	ABC	Oct-23
4	KR	111	ABC	Oct-23
5	AS	111	ABC	Dec-23
1	AV	111	ABC	Dec-23
2	VA	111	ABC	Dec-23
2	VA	111	ABC	Oct-23
2	VA	111	ABC	Dec-23
2	VA	111	ABC	Dec-23
3	RK	111	ABC	Dec-23
3	RK	111	ABC	Aug-23
3	RK	111	ABC	Aug-23
3	RK	111	ABC	Aug-23
5	AS	111	ABC	Aug-23
5	AS	111	ABC	Aug-23
5	AS	111	ABC	Dec-23
5	AS	111	ABC	Dec-23
5	AS	111	ABC	Aug-23
5	AS	111	ABC	Nov-23
2	VA	111	ABC	Sep-23
2	VA	111	ABC	Sep-23