topic DAX Cheat Sheet - Success of CSS Selector in Data Stories Gallery

DAX Cheat Sheet - Success of CSS Selector

EricDong — Sat, 03 Nov 2018 07:06:20 GMT

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

Re: DAX Cheat Sheet - Success of CSS Selector

chass — Tue, 27 Nov 2018 01:59:21 GMT

Great job Eric!

Re: DAX Cheat Sheet - Success of CSS Selector

JasperS — Wed, 11 Sep 2019 11:35:37 GMT

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

Re: DAX Cheat Sheet - Success of CSS Selector

Tkb7117 — Fri, 29 May 2020 13:59:01 GMT

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

Re: DAX Cheat Sheet - Success of CSS Selector

JamesDBartlett3 — Thu, 11 Mar 2021 21:31:32 GMT

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

Re: DAX Cheat Sheet - Success of CSS Selector

Nia — Wed, 27 Apr 2022 12:44:12 GMT

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

Thank you

Re: DAX Cheat Sheet - Success of CSS Selector

Anonymous — Tue, 30 Aug 2022 18:41:56 GMT

Hello,,

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

ediz.eracar@gmail.com

Thank you,

Re: DAX Cheat Sheet - Success of CSS Selector

J_Sekellick — Sun, 06 Nov 2022 17:09:06 GMT

This is pretty awesome!!

Re: DAX Cheat Sheet - Success of CSS Selector

Anonymous — Tue, 11 Jul 2023 18:54:49 GMT

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!

Re: DAX Cheat Sheet - Success of CSS Selector

PijushRoy — Tue, 12 Dec 2023 06:53:34 GMT

Very useful information, Thanks for sharing

Re: DAX Cheat Sheet - Success of CSS Selector

rptanalyst — Sun, 25 May 2025 20:38:12 GMT

that an amazing work done by you. and helpful for everyone. well done.