cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JShafer26554
Frequent Visitor

Creating Logic within Power Query Editor?

Hi all,

 

Novice PowerBI user here. I have a few queries that I have loaded within a workbook, and I'm attempting to create a column within that table that looks at ANOTHER table, takes the latest date we have (in this case, would be 6/14/2021), and populates the column with it.

 

Is there some easy way to figure this out, or am I grasping at straws?

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @JShafer26554 ,

 

this is not easy as one would hope, this is because referencing other tables (other queries) from within a query requires some M code.

 

Then you can consider using List.Max (<List.Max - PowerQuery M | Microsoft Docs) in combination with Table.SelectColumns (Table.SelectColumns - PowerQuery M | Microsoft Docs) to store the MAX date.

 

If you need more guidance, create a pbix that contains sample data, but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data, share the xlsx as well.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

4 REPLIES 4
TomMartens
Super User
Super User

Hey @JShafer26554 ,

this is great!

Maybe you will find some time to provide a short outline of your solution and mark your post as an answer, as this will help others who have similar questions.

Thanks,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
HashamNiaz
Super User
Super User

Hi @JShafer26554 !

 

You can first create a relationship between these table, like any joining key which is common in 2 tables, then use RELATEDTABLE() DAX function to achive the results;

 

RELATEDTABLE() 

 

Regards,

Hasham

TomMartens
Super User
Super User

Hey @JShafer26554 ,

 

this is not easy as one would hope, this is because referencing other tables (other queries) from within a query requires some M code.

 

Then you can consider using List.Max (<List.Max - PowerQuery M | Microsoft Docs) in combination with Table.SelectColumns (Table.SelectColumns - PowerQuery M | Microsoft Docs) to store the MAX date.

 

If you need more guidance, create a pbix that contains sample data, but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data, share the xlsx as well.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Thanks Tom! I actually sat down with a coworker who has a little more PowerBI experience than I do and we were able to use your suggestion to find an effective solution!

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!