DAX Cheat Sheet - Success of CSS Selector

Occasional Visitor
913 Views
Occasional Visitor
Posts: 1
Registered: ‎11-02-2018

DAX Cheat Sheet - Success of CSS Selector

[ Edited ]

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.

 

Administrator
Posts: 211
Registered: ‎03-22-2016

Re: DAX Cheat Sheet - Success of CSS Selector

Great job Eric!