Forum Discussion
DAX help for Vlookup
HI Experts,
Can I create a vlookup formula using dax based on below conditons
I have a table with ID and Reporting date
And another table with same ID, Status. Raised date and Closure date .
I need to add Status in the first table baed on below two conditions
if Reporting date >= Raised date &&
Reporting date <= Closure date then I need to show staus.
Please help
Anonymous
pls try this
Column = maxx(FILTER('Table (2)','Table (2)'[ID]='Table'[ID]&&'Table'[Reporting date]>='Table (2)'[Raised date]&&'Table'[Reporting date]<='Table (2)'[Closure date]),'Table (2)'[Status])the date of 100 does not between the raised date and closure date. So shall we display blank?
pls see the attachment below
8 Replies
pls provide some sample data
Project ID Reporting date Status 100 01-01-2023 Yes 100 04-01-2023 101 01-01-2023 No 101 04-01-2023 Project ID Raised date Closure date Status 100 01-01-2023 15-01-2023 Yes 101 10-01-2022 15-01-2022 No 101 01-01-2023 03-01-2023 No ryan_mayu , please check
Anonymous
pls try this
Column = maxx(FILTER('Table (2)','Table (2)'[ID]='Table'[ID]&&'Table'[Reporting date]>='Table (2)'[Raised date]&&'Table'[Reporting date]<='Table (2)'[Closure date]),'Table (2)'[Status])the date of 100 does not between the raised date and closure date. So shall we display blank?
pls see the attachment below