Forum Discussion
Helper IIINeed formula help
Solution SageIf there are no relationships between the tables, you should be using LOOKUPVALUE or TREATAS.
Helper IIIok. I did sorta get it to work. using lookupvalue. However, the issue is from Table 1. The adj column is not filling in all the way, so I first need to get issue in table 1 fixed. here is my dax code for adj column in table 1. can anyone help fix this?
Thank you!
- sjoerdvn
mmm, didn't you say that your date columns where actually text type? If that is the case than things like MIN, MAX and EARLIER are not going to work if the date format is mmm-yy.
So you would need to create a proper date column first, and although you could try that in DAX, I would advice to do that in Power Query or even in the source if that's possible.- yaya1974
Correct they were text, but I did already switch to date, to get the lookupvalue to work.
Biggest issues is getting all rows to fill in. Thanks!
Hi, yaya1974
May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.