Shared Keyword
#shared Say (say, say), say the magic word SHARED - S.H.A.R.E.D. In Power BI , there is Power Query M which is functional language. Knowing as many as possible functions you can, it's the best assistant when you have to do something writing M language. In this post we wil l talk about the shared keyword. There are many times that you need to go the manual of M language and search for the syntax of a function. 👉What if you have the entire manual in a single query, inside the Power BI in order to read the syntax and test the function ? Open Power Query editor, go to New Source and choose Blank Query . Then go to query, right-click and choose Advanced Editor . At the advanced editor pane, delete all content here and only type in: #shared , and then press done. The r esult set here is a query that has functions, enumerators, and queries in each item of the record. ...