Forum Discussion
Referencing max date from another table in power query
Hi Anonymous
You can solve it easily with the ux options of PQ.
1. First step is to merge the tables :2. Second when expanding just choose the wanted aggregation:
3. fix data type of result to date:
Pbix is attached you can follow my steps
Anonymous
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
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.
Super UserHi Anonymous
You can solve it easily with the ux options of PQ.
1. First step is to merge the tables :
2. Second when expanding just choose the wanted aggregation:
3. fix data type of result to date:
Pbix is attached you can follow my steps
I don't want to merge tables, I wanted to reference the other table.
- Ritaf1983
Anonymous
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 it