Forum Discussion
Adding columns from different tables based on date
Community SupportHi Anonymous ,
You can take try of “Merge” option in query edit.
Click “Merge Queries as New” to generate a new table under the condition of date matching:
Alternatively, you can using DAX :
Price = LOOKUPVALUE(Table1[Price],Table1[Date],Table2[Date])
So to be more specific, I'm in DAX and I've typed out a lot of summarized columns for a few different things, and I'm having trouble just simply adding a single column of values that correlate with the date. I was keeping it simple for explantions sake earlier, but now I can't seem to figure out how to add on that last column. Merge queries isn't an option at this point with the way the new table is set up. I think the Add Column tool will be the solution but I don't know how to get the prices to go right alongside everything else
- v-frfei-msft
Hi Anonymous ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.