Forum Discussion
Add column based on lookup in same table
Hi, I'm trying to understand how I can create a column with a Lookup in the same table using a DAX expression In excel it would look like this, I'm looking to match the records of the last mo...
Hi Anonymous ,
Create a Calculated Column
Column = LOOKUPVALUE(Table5[Records],Table5[Date],Table5[Last Month Date])Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
I added some sample data here :https://we.tl/t-FjCIeSQH5R
Hi Anonymous ,
Create a Calculated Column
Column = LOOKUPVALUE(Table5[Records],Table5[Date],Table5[Last Month Date])
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)