Course code: MBI0012
Hands on Power BI DAX training to enable attendees to create complex calculations in DAX
An working knowledge of Power BI or,
Power BI Fundamentals
Hands on Dax training course designed for Power BI users who now want to harness power of DAX formulas within Power BI.
Attendees will work through pracitical hands on session to create complex calculations to enable attendees to take data analysis well beyond that available within the standard toolset.Learn how to use variables, create write time intelligence calculations, cumulative totals, dynamic titles, DAX studio to debug and increase performance For those wanting to take this course in house, iTrain tailor content to your specific to your organisation's business and projet objectives.
DAX FundamentalsCommonly Used DAX FunctionsSum, Average, Count, DistinctCountCreate a measure tableCopying and Moving MeasuresUse Variables in calculationDifferent granularity: calculate allocated weightDAX STUDIODax as a query languageDax Studio - capturing and debugging queriesPower BI referencingCONTEXTFilter context Evaluation Contexts and RelationshipsUnderstand the use of CALCULATETable Functions: ALL, ALLEXCEPT, FILTERTable Functions: DISTINCT, VALUESAdvanced Evaluation Context DAX Context transitionIterator -> nested row contextRow context and TotalsRow context and cumulative totalTIME INTELLIGENCE Time Intelligence prerequisitesTime intelligence functions MTD, QTD, YTD, SamePeriodLastYearYTD, MTD with CALCULATERolling totals for different periodsIF, HasOneValueUsing a Safe Divide FunctionUsing the Blank() FunctionCreating Dynamic titlesUsing parameter tableWhat is scenarios
Terms and Conditions
© 2020 iTrain. All rights reserved.