Advocate IDAX Cheat Sheet - Success of CSS Selector
This report is sourcing from MS official DAX Reference site by using a dynamic way to extract the data based on CSS selector; Visit my blog for more Power BI tips and tricks: funbiworld.com
Methods:
Using CSS selector to directly retrieve Functions Name and Link from the parent (DAX Category) page. Then use Custom Functions to get details per each Link.
Key M Scripts:
Source = Web.BrowserContents(DaxGroupURL),
#"Extracted Table From Html" = Html.Table(Source, {{"FunctionName", "[id*=""api-doc-contents""] > H1,[id*=""api-doc-contents""] > P,[id*=""api-doc-contents""] > H2"},{"Link", "a[href]", each [Attributes][href]}},[RowSelector="[id*=""api-doc-contents""] > H1,[id*=""api-doc-contents""] > P,[id*=""api-doc-contents""] > H2"]),
Custom Visuals:
Using Hierarchy Slicer and Text Filter to make a better browsing experience.
10 Replies
- chass
Impactful Individual
Great job Eric!
- JamesDBartlett3
Advocate II
EricDong Do you still have the .pbix file for this, by any chance?
Hi, this is so useful! Is it possble to receive the Pbix?
Thank you
Hello,,
This is awsome. Is it possible you can send me the pbix file for this?
Thank you,
- J_Sekellick
This is pretty awesome!!
EricDong , this is absolutely awesome and so useful! By any chance, would you be willing to share the pbix file with me? I'm hopeful that I can learn a lot from this. Many thanks!
- PijushRoy
Community Champion
Very useful information, Thanks for sharing
that an amazing work done by you. and helpful for everyone. well done.
