I've been working through the DAX learning path on Learn & found a tip on RELATEDTABLE that was so wonderfully clear I wanted to share it with the world:
"Notice that the formula uses the RELATED function. Remember, row context does not extend beyond the table. If your formula needs to reference columns in other tables, and there are model relationships between the tables, use the RELATED function for the one-side, or the RELATEDTABLE function for the many-side."
I immediately went to the RELATEDTABLE docs page to see if this gem existed there as well. Sadly, this page's functional documentation is very sparse. I went to check the contributors but the Github link is broken.
If there are any powers who can lift that wonderful Learn content and get it to the DAX documentation page it would be well worth your time!
Solved! Go to Solution.
@equerystrian - Might be worth a shot posting this to the Issues board. I have posted some documentation omissions and errors there and had some marginal success with getting things fixed. Worth a try anyway!
@equerystrian - Might be worth a shot posting this to the Issues board. I have posted some documentation omissions and errors there and had some marginal success with getting things fixed. Worth a try anyway!
Thanks @Greg_Deckler, I've posted it as an Idea in the Issues forum. https://community.powerbi.com/t5/Issues/Updated-RELATEDTABLE-documentation-with-content-from-Learnin...
@equerystrian - Cool, I voted for it! 🙂
User | Count |
---|---|
93 | |
38 | |
37 | |
15 | |
14 |
User | Count |
---|---|
102 | |
31 | |
28 | |
20 | |
15 |