Forum Discussion

botaac's avatar
botaac
Frequent Visitor
3 years ago
Solved

Calculated Column Based on two tables

I have two tables: Table 1 Name Email John Doe [email protected] John Doe [email protected] Larry Fitz [email protected] John Elway [email protected] John Elway John...
calculated column
DAX
new column
power bi
tables
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi botaac ,

    Please try to create a new column with below dax formula:

    Eligibility =
VAR cur_date =
    TODAY ()
VAR _date =
    LOOKUPVALUE ( Table2[Date Submitted], Table2[Name], Table1[Name] )
VAR _val =
    DATEDIFF ( cur_date, _date, MONTH )
RETURN
    IF ( ISBLANK ( _date ), "No", IF ( _val > 3, "No", "Yes" ) )

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi botaac 

try like:

Eligibility =
VAR _date =
LOOKUPVALUE(
    Table2[Date Submitted],
    Table2[Name],
    Table1[Name]
)
RETURN
IF(
    _date>=EDATE(TODAY(),-3),
    "Yes", "No"
)