kmx.io/prism.js/examples/prism-dax.html

• Show log

  Commit

• Hash : 9227853f
  Author :
  Date : 2020-03-13T21:52:26
  

  Added support for DAX (#2248) This adds support for DAX (Data Analysis Expressions). https://docs.microsoft.com/en-us/dax/

Download

• examples/prism-dax.html

• <h2>Comments</h2>
  <pre><code>// This is a comment</code></pre>
  <h2>Simple example</h2>
  <pre><code>
  Sales YTD := 
  CALCULATE (
      [Sales Amount], 
      DATESYTD( 'Date'[Date] )
  )
  </code></pre>
  <h2>Full example</h2>
  <pre><code>
  Burn Rate (Hours) = 
  
  // Only consider those projects which have been alread created
  VAR filterDate = 
      FILTER (
          ALL ( 'Date'[Date] ),
          'Date'[Date] &lt;= MAX('Date'[Date])
      )
  
  RETURN
  IF (
      // Show blank for months before project start
      MAX ( 'Project'[Project Created Relative Months Pos] ) &lt; SELECTEDVALUE ( 'Date'[Fiscal RelativeMonthPos] ),
      BLANK (),
      MIN(
          1,
          DIVIDE (
              // Add 0 to consider months with no hours
              [Hours Actual Billable] + 0,
              CALCULATE (
                  [Planned Hours] + 0,
                  filterDate
              )
          )
      )
  )
  </code></pre>
  

Download