Forum Discussion

amaleranda's avatar
amaleranda
Post Patron
6 years ago
Solved

Add a column to a Data table from another lookup table

Hello Gurus,   I have a lookup tabel like below(Image1). I need to add a new column (Revision Number) to my continues data tabel(Image2) based on below condition. my date tabel has only one column ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • vivran22's avatar
    vivran22
    6 years ago

    Hello amaleranda 

     

    Try this:

    RevisionNumber = 
CALCULATE(
       VALUES(Image1[Revision Number]),
FILTER(
Image1,
Image2[Date]>= Image1[Revsion_Start_Date]
&&
Image2[Date] <= Image1[Revsion_End_Date]
)
)

    Cheers!
    Vivek

    If it helps, please mark it as a solution
    Kudos would be a cherry on the top 🙂

    https://www.vivran.in/

    Connect on LinkedIn

     

vivran22's avatar
vivran22
Community Champion
6 years ago

Hello amaleranda 

 

Try this:

RevisionNumber = 
CALCULATE(
       VALUES(Image1[Revision Number]),
FILTER(
Image1,
Image2[Date]>= Image1[Revsion_Start_Date]
&&
Image2[Date] <= Image1[Revsion_End_Date]
)
)

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

 

amaleranda's avatar
amaleranda
Post Patron
6 years ago

vivran22  works a magic. thanks mate