www.interfacett.com Open in urlscan Pro
92.204.135.129  Public Scan

Submitted URL: http://click.email.interfacett.com/?qs=d83ce32fada10c273bf2d1534938f2ef55993e9fe2732a4459b545eb847c351defcaed75848404e82a2afbb3b332...
Effective URL: https://www.interfacett.com/training/pbical-introduction-to-dax-for-power-bi-desktop-users-level-3
Submission: On January 12 via manual from US — Scanned from DE

Form analysis 3 forms found in the DOM

GET /search/

<form role="search" method="get" class="search-form" action="/search/"> <label> <span class="screen-reader-text">Search our courses</span> <input type="search" class="search-field" placeholder="Search our courses…" value="" name="ks"> </label> <input
    type="submit" class="search-submit" value="Search"></form>

POST /training/pbical-introduction-to-dax-for-power-bi-desktop-users-level-3#gf_14

<form method="post" enctype="multipart/form-data" target="gform_ajax_frame_14" id="gform_14" action="/training/pbical-introduction-to-dax-for-power-bi-desktop-users-level-3#gf_14" novalidate="">
  <div class="gform_body gform-body">
    <ul id="gform_fields_14" class="gform_fields top_label form_sublabel_below description_below">
      <li id="field_14_10" class="gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_10">
        <div class="ginput_container ginput_container_text"><input name="input_10" id="input_14_10" type="hidden" class="gform_hidden" aria-invalid="false" value=""></div>
      </li>
      <li id="field_14_1" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_1"><label class="gfield_label" for="input_14_1">First Name<span
            class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label>
        <div class="ginput_container ginput_container_text"><input name="input_1" id="input_14_1" type="text" value="" class="medium" tabindex="1000" placeholder="* First Name" aria-required="true" aria-invalid="false"></div>
      </li>
      <li id="field_14_5" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_5"><label class="gfield_label" for="input_14_5">Last Name<span
            class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label>
        <div class="ginput_container ginput_container_text"><input name="input_5" id="input_14_5" type="text" value="" class="medium" tabindex="1001" placeholder="* Last Name" aria-required="true" aria-invalid="false"></div>
      </li>
      <li id="field_14_3" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_3"><label class="gfield_label" for="input_14_3">Email<span class="gfield_required"><span
              class="gfield_required gfield_required_asterisk">*</span></span></label>
        <div class="ginput_container ginput_container_text"><input name="input_3" id="input_14_3" type="text" value="" class="medium" tabindex="1002" placeholder="* Email" aria-required="true" aria-invalid="false"></div>
      </li>
      <li id="field_14_4" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_4"><label class="gfield_label" for="input_14_4">Phone<span class="gfield_required"><span
              class="gfield_required gfield_required_asterisk">*</span></span></label>
        <div class="ginput_container ginput_container_text"><input name="input_4" id="input_14_4" type="text" value="" class="medium" tabindex="1003" placeholder="* Phone" aria-required="true" aria-invalid="false"></div>
      </li>
      <li id="field_14_2" class="gfield field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_2"><label class="gfield_label" for="input_14_2">Company</label>
        <div class="ginput_container ginput_container_text"><input name="input_2" id="input_14_2" type="text" value="" class="medium" tabindex="1004" placeholder="Company" aria-invalid="false"></div>
      </li>
      <li id="field_14_8" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_8"><label class="gfield_label" for="input_14_8">Timeframe<span
            class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label>
        <div class="ginput_container ginput_container_textarea"><textarea name="input_8" id="input_14_8" class="textarea medium" tabindex="1005" placeholder="* What is your time frame for this class?" aria-required="true" aria-invalid="false"
            rows="10" cols="50"></textarea></div>
      </li>
      <li id="field_14_9" class="gfield field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_9"><label class="gfield_label" for="input_14_9">Comments</label>
        <div class="ginput_container ginput_container_textarea"><textarea name="input_9" id="input_14_9" class="textarea medium" tabindex="1006" placeholder="Comments:" aria-invalid="false" rows="10" cols="50"></textarea></div>
      </li>
      <li id="field_14_11" class="gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_11">
        <div class="ginput_container ginput_container_text"><input name="input_11" id="input_14_11" type="hidden" class="gform_hidden" aria-invalid="false" value="Request A Date"></div>
      </li>
      <li id="field_14_12" class="gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible" data-js-reload="field_14_12"><label class="gfield_label" for="input_14_12">Comments</label>
        <div class="ginput_container"><input name="input_12" id="input_14_12" type="text" value="" autocomplete="new-password"></div>
        <div class="gfield_description" id="gfield_description_14_12">This field is for validation purposes and should be left unchanged.</div>
      </li>
    </ul>
  </div>
  <div class="gform_footer top_label"> <input type="submit" id="gform_submit_button_14" class="gform_button button" value="Submit" tabindex="1007"
      onclick="if(window[&quot;gf_submitting_14&quot;]){return false;}  if( !jQuery(&quot;#gform_14&quot;)[0].checkValidity || jQuery(&quot;#gform_14&quot;)[0].checkValidity()){window[&quot;gf_submitting_14&quot;]=true;}  "
      onkeypress="if( event.keyCode == 13 ){ if(window[&quot;gf_submitting_14&quot;]){return false;} if( !jQuery(&quot;#gform_14&quot;)[0].checkValidity || jQuery(&quot;#gform_14&quot;)[0].checkValidity()){window[&quot;gf_submitting_14&quot;]=true;}  jQuery(&quot;#gform_14&quot;).trigger(&quot;submit&quot;,[true]); }"><input
      type="hidden" name="" value=""><input type="hidden" name="" value=""> <input type="hidden" name="gform_ajax" value="form_id=14&amp;title=&amp;description=&amp;tabindex=0"> <input type="hidden" class="gform_hidden" name="is_submit_14" value="1">
    <input type="hidden" class="gform_hidden" name="gform_submit" value="14"> <input type="hidden" class="gform_hidden" name="gform_unique_id" value=""> <input type="hidden" class="gform_hidden" name="state_14"
      value="WyJbXSIsImVhZGE5ZTI3MzA0OWQ2MjYyZDA0NTNkMGYzNTkxYmI2Il0="> <input type="hidden" class="gform_hidden" name="gform_target_page_number_14" id="gform_target_page_number_14" value="0"> <input type="hidden" class="gform_hidden"
      name="gform_source_page_number_14" id="gform_source_page_number_14" value="1"> <input type="hidden" name="gform_field_values" value=""></div>
  <p style="display: none !important;"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="1673562042944">
    <script>
      document.getElementById("ak_js_1").setAttribute("value", (new Date()).getTime());
    </script>
  </p>
</form>

<form id="wp-link" tabindex="-1"> <input type="hidden" id="_ajax_linking_nonce" name="_ajax_linking_nonce" value="1a93879876">
  <h1 id="link-modal-title">Insert/edit link</h1> <button type="button" id="wp-link-close"><span class="screen-reader-text">Close</span></button>
  <div id="link-selector">
    <div id="link-options">
      <p class="howto" id="wplink-enter-url">Enter the destination URL</p>
      <div> <label><span>URL</span> <input id="wp-link-url" type="text" aria-describedby="wplink-enter-url"></label></div>
      <div class="wp-link-text-field"> <label><span>Link Text</span> <input id="wp-link-text" type="text"></label></div>
      <div class="link-target"> <label><span></span> <input type="checkbox" id="wp-link-target"> Open link in a new tab</label></div>
    </div>
    <p class="howto" id="wplink-link-existing-content">Or link to existing content</p>
    <div id="search-panel">
      <div class="link-search-wrapper"> <label> <span class="search-label">Search</span> <input type="search" id="wp-link-search" class="link-search-field" autocomplete="off" aria-describedby="wplink-link-existing-content"> <span
            class="spinner"></span> </label></div>
      <div id="search-results" class="query-results" tabindex="0">
        <ul></ul>
        <div class="river-waiting"> <span class="spinner"></span></div>
      </div>
      <div id="most-recent-results" class="query-results" tabindex="0">
        <div class="query-notice" id="query-notice-message"> <em class="query-notice-default">No search term specified. Showing recent items.</em> <em class="query-notice-hint screen-reader-text">Search or use up and down arrow keys to select an
            item.</em></div>
        <ul></ul>
        <div class="river-waiting"> <span class="spinner"></span></div>
      </div>
    </div>
  </div>
  <div class="submitbox">
    <div id="wp-link-cancel"> <button type="button" class="button">Cancel</button></div>
    <div id="wp-link-update"> <input type="submit" value="Add Link" class="button button-primary" id="wp-link-submit" name="wp-link-submit"></div>
  </div>
</form>

Text Content

PRESS RELEASE: INTERFACE ACQUIRES CENTRIQ'S CORPORATE
IT TRAINING BUSINESS - WE ARE EXPANDING!   (Jan 5, 2023)

LEARN MORE
Search our courses
1-800-264-9029|602-266-8500
 * Course Schedule
   * Microsoft Training
     * Microsoft Fundamentals Training
     * Windows Client
     * Teams
     * Teams / Microsoft 365 / MS365
     * Windows Server 2019
     * SQL Server Transact-SQL
     * SQL Server Administration
     * SQL Server Business Intelligence
     * Power BI
     * Power Platform
     * Azure
     * Data Engineering / Machine Learning
     * Artificial Intelligence (AI)
     * M365 Messaging
     * PowerShell
     * System Center
     * SharePoint
     * Microsoft Security
   * Cloud Computing
     * Azure
     * Amazon Cloud (AWS)
   * Developer Training
     * DevOps
     * Web Development
     * .NET Development and Visual Studio
     * Java Programming
     * Python
   * Cisco Training
     * Cisco CCNA
     * Cisco Routing and Switching
     * Cisco Security
     * Cisco Wireless
     * Cisco Data Center and Storage
     * Cisco Collaboration
     * Cisco Contact Center
     * Cisco DevNet
   * CompTIA Certification
     * CompTIA A+
     * CompTIA CASP+
     * CompTIA Linux+
     * CompTIA Network+
     * CompTIA Project+
     * CompTIA Security+
   * Business Training
     * Project Management
     * ITIL
     * NIST
     * Business Analysis (PBA & CBAP)
     * Agile
   * Security Training
     * ISC2
     * Microsoft Security
     * CompTIA Security
     * NIST
     * Cisco Security
   * Wireless Training
     * Wireless Networking
   * Other Training
     * VMware
     * NetApp
     * F5 Networks
     * Citrix
     * Microsoft Excel
 * Exams
   * Student Pricing
 * Subscriptions
 * Interface Gold
   * RemoteLive™
   * Replay™
   * Interface Gold™ Benefits
 * On-Demand
 * Resources
   * Tech Blogs
   * Tech Videos
   * Microsoft Learn Catalog
 * About
   * Instructors
   * Interface TechPak
   * Group Training & Private Classes
   * Contact

home > training > PBICAL: Introduction to DAX for Power BI Desktop Users – Level
3
Print Page



PBICAL: INTRODUCTION TO DAX FOR POWER BI DESKTOP USERS – LEVEL 3

$1,190

 * 2 Days



Dates Available
Class Time Time Zone: PhoenixTime Zone: PacificTime Zone: MountainTime Zone:
CentralTime Zone: Eastern
Guaranteed
to Run
Attend
Live Online
Rewatch with
Replay™
 

Jan 12 - Jan 13
8AM - 4PM (PHX)
7AM - 3PM (PT)
8AM - 4PM (MT)
9AM - 5PM (CT)
10AM - 6PM (ET)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online

Register

Mar 23 - Mar 24
7AM - 3PM (PHX)
7AM - 3PM (PT)
8AM - 4PM (MT)
9AM - 5PM (CT)
10AM - 6PM (ET)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Attend Live Online

Register

x
Course:
 * 
 * First Name*
   
 * Last Name*
   
 * Email*
   
 * Phone*
   
 * Company
   
 * Timeframe*
   
 * Comments
   
 * 
 * Comments
   
   This field is for validation purposes and should be left unchanged.



Δ


Course Description

This course takes an in-depth approach to the DAX language, teaching designers
how to build models that extend the capabilities of source data for more
in-depth, customized business intelligence solutions. Topics covered include
proper understanding of DAX evaluation, controlling evaluation context,
understanding relational functions, error handling within the data model,
working with complex time intelligence calculations.

Outline

Lesson 1: Basic DAX Functionality

 * Review of Calculated Columns
 * Review of Measures
 * Rules of Evaluation
 * Evaluation Context
 * Formatting DAX Code

 

Lesson 2: Controlling Content & Values

 * Controlling Values – DAX
 * Error Handling

 

Lesson 3: Content Control Functions

 * Iterative Functions
 * The FILTER Function
 * The ALL Function
 * The CALCULATE Function

 

Lesson 4: Contexts In Relationships

 * Working With Many Tables
 * Row Context & Relationships
 * Elevated Calculated Columns
 * Filter Context & Relationships
 * Cross Filtering Issues

 

Lesson 5: Time Intelligence Functions

 * Calculating Operating Periods
 * To-Date Functions
 * Controlling Totals
 * Advanced Date Functions
 * Prior Year Functions

 

Lesson 6: Appendix – Advanced Concepts

 * Additional Uses Of The ALL Function
 * Advanced Data Tables
 * Working with Missing Periods
 * Working with Non-standard Years
 * Parameter Tables
 * Banding

Prerequisites

PBICDMD: Data Model Design using Power BI Desktop – Level 2

ABOUT US

 * Interface Gold™ Benefits
 * Interface TechPak
 * Group Training & Private Classes

CONTACT US

3115 N 3rd Ave
G130
Phoenix, AZ 85013

602-266-8500



Stay in touch on our social channels!
Twitter
Facebook
LinkedIn
State of Arizona Contract # ADSPO18-210228

Copyright © 2023 Interface Technical Training. All Rights Reserved.

Interface Live Training Terms and Conditions Terms of Use Microsoft Subscription
Terms and Conditions Privacy Policy WIOA Policy





INSERT/EDIT LINK

Close

Enter the destination URL

URL
Link Text
Open link in a new tab

Or link to existing content

Search

No search term specified. Showing recent items. Search or use up and down arrow
keys to select an item.

Cancel








Notifications