DAX Cheat Sheet - Success of CSS Selector 05-29-2020 06:59 AM

[EricDong]

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.

eyJrIjoiMWI2YjFmZDAtNWRlYy00ZDliLWEzMGYtZjUzOGVmMGFlN2Q2IiwidCI6ImJlZWY0NDQyLTg2NzgtNDM0MC1hYWQwLTlmZDY2Yjg1ZjRlYSJ9

[J_Sekellick]

This is pretty awesome!!

[911Kid]

Hello,,

This is awsome. Is it possible you can send me the pbix file for this? 

ediz.eracar@gmail.com

Thank you,

[Nia]

Hi, this is so useful! Is it possble to receive the Pbix?

Thank you

[JBartlett_DMU]

@EricDong Do you still have the .pbix file for this, by any chance?

[chass]

Great job Eric!

[JasperS]

Hi Eric,

Great job sir!

is it possible you can send me the data file and pbix file for this?  would be very educational for me as a beginner and would realy help my learning

[Tkb7117]

hi is it possble to receive the Pbix - thanks in advance