Forum Discussion
Helper IHow to get a column from table B into Table A?
MartinC Not 100% positive I am fully tracking the issue but perhaps this?
Column = VAR __ID = [ID] VAR __Result = MAXX(FILTER('UDFS',[ID] = __ID && [UDFID] = 68),[UDFValue]) RETURN __Result
Helper IGreg_Deckler I see my error (but don't know how to fix it) - ID in table UDFS has multiple UDFID values - is there a way to filter for the UDFID value of 68 to give the UDFValue for those only? Thanks 🙂
- Greg_Deckler
Community Champion
MartinC Not 100% positive I am fully tracking the issue but perhaps this?
Column = VAR __ID = [ID] VAR __Result = MAXX(FILTER('UDFS',[ID] = __ID && [UDFID] = 68),[UDFValue]) RETURN __Result- MartinC
Greg_Deckler you are officially my hero! Thank you so much! Side question - where is the best place to learn this sort of thing? I would never have gotten to that solution on my own.
- Greg_Deckler
MartinC That's a great question. I actually just started a new YouTube channel focused on making DAX easy: (2) DAX for Humans - YouTube. I literally just started the channel yesterday. Also, I know that Ben Ferry does some great stuff on his channel and has some "DAX is Easy" stuff in the works, https://www.youtube.com/channel/UCtg3Z9zZSAOkOWCHd-GPbVg.
There is a ton of good community content out there but not sure if there is one single thing that takes you from absolute zero and teaches DAX in a logical, incremental manner (hence why I created DAX For Humans). There are a number of self-guided learning paths here: Power BI on Microsoft Learn | Microsoft Learn. Also radacad has a bunch of stuff and sqlbi. RickdeGroot put together an awesome page that summarizes all of the various stuff out there: Best Resources to Learn Power BI in 2023 (incl DAX, M).
Then there are all the books. I have Learn Power BI 2nd Edition which has an introduction to DAX (very light). My book DAX Cookbook has a bunch of recipes for various different DAX calculations. I also like Beginning DAX with Power BI by Philip Seamark and MattAllington's books, Learn to Write DAX and Supercharge Power BI.
- MartinC