Forum Discussion
Referencing max date from another table in power query
Super UserAnonymous
This is how it works with power query, you need to merge tables.
You can write M code / use ux but the logic is the same.
Refer to other tables without merging possible with DAX calculated columns.
In your scenario it is by combining
Maxx + relatedtable.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
No, you don't. Vijay_A_Verma provided the exact solution I was looking for without merging tables.
- Ritaf1983
Ok, great to know.
Where is the solution?
For some reason I don't see itGood question. I don't know why/how but looks like they split the posts when I marked it as an answer. For anyone else looking seems to be here:
- Ritaf1983
Hi Anonymous
I saw the solution, did you want to bring maximum date without referencing to the category?
Because it is not the same result as a merging ...
It brings the latest date by table level.