How did I format my DAX expression in a post?

June 26, 2024 admin Power BI 0


To format a DAX expression, I utilize the HTML view of the posts to copy in a formatted div tag and the html of the formatted DAX expression generated by https://www.daxformatter.com/.

 

  1. Click on the HTML button in the top bar of the post (you may need to click “…” to have it show)
  2. Paste in the tag below.
  3. Copy DAX expression.
  4. Paste into https://www.daxformatter.com/ and then click “Copy HTML”.
  5. Paste in the HTML DAX code from dax formatter before

(where the comment is).

  • Click OK.

    • The formatted

    tag (which can be further modified as you like!):

     

     

     

    DataZoe_0-1606164559618.png

    This will format the DAX expression to look like this:

    Measure Cumulative =
    CALCULATE (
        [Measure],
        FILTER (
            ALLSELECTED ( ‘Date'[Date] ),
            ISONORAFTER ( ‘Date'[Date], MAX ( ‘Date'[Date] ), DESC )
        )
    )



    Source link

    Be the first to comment

    Leave a Reply

    Your email address will not be published.


    *