In which Johnny demonstrates 3 methods you can use to create Dynamic or Switching measures, including how to use disconnected tables with the SWITCH function in DAX and also how to use calculation groups.
The finale is Johnny's ULTIMATE method for dynamic measures which even includes how to use Tabular Editor to script out a calculation group.
References:
Workout Wednesday - week 8
www.workout-wed...
Greyskull Analytics Github
github.com/Gre...
Chapters:
0:00 Intro
0:37 What is Workout Wednesday
2:04 Method 1 - using SWITCH
5:00 Method 2 - using FORMAT
7:12 Method 3 - using a Calculation Group
14:55 Using Tabular Editor scripting
19:55 The ULTIMATE Dynamic Measures method
#PowerBI #PBI #BusinessIntelligence #TabularEditor #DAX #CalculationGroups
Credits:
background music: www.streambeat...
sound effects: soundbible.com/
gifs: giphy.com/
title music: written and recorded by ME!!!
Негізгі бет Power BI ULTIMATE Guide to Dynamic Measures
No video
Пікірлер: 33