October 19, 2020

Syntax Sugar – SUM Is SUMX In Disguise

ContentsQuick IntroductionSUM vs SUMXDemonstrationSUM is simplerSUMX is more powerfulManipulating Tables with SUMXWorking beyond One Column with SUMXConclusion Quick Introduction Do you know syntax sugar? May be […]
October 12, 2020
Security Restriction

Practical Introduction to DAX (Intro to Row Level Security)

ContentsUsing DAX to implement Data ConfidentialityThe Case StudyCreating Row Level Security in Power BI DesktopTesting the Roles on Power BI DesktopActivating the RLS on Power BI […]
October 10, 2020
Waterfall Chart in Power BI

How To Use Waterfall Charts In Power BI

When talking about charts that are uncommonly used in Power BI, Waterfall Chart is usually not so far down on the list. Why? Who knows? Maybe […]
October 4, 2020

Practical Introduction to DAX (Intro to Measures)

ContentsOverviewMeasures in Power BIHow to Create a MeasureThings Worth knowing about MeasuresIngredients to Master MeasuresConclusion Overview In this series, I have introduced Calculated Tables, Calculated Columns, […]
October 2, 2020

New DAX Course Launch

ContentsLearning DAXNew DAX CourseWhat You Will Learn The Gift Learning DAX Read until end (Gift included). DAX is NOT one of the easiest Languages to learn (It’s […]
September 26, 2020

Practical Introduction to DAX (Intro to Calculated Columns)

ContentsOverviewUnderstand the Demo DataHow to create Calculated Columns.Task 1: Create a “New Column” for CostTask 2: Create a “New Column” for Sales SizeThe IF methodThe SWITCH […]
September 26, 2020
A Scatter Chart in Power BI

How To Use Scatter Charts in Power BI

ContentsOverviewCase StudyCreating a Basic Scatter PlotEnhancing the Scatter Plot Showing the Labels of the MarksCreating Quadrants and Trend LinesAnimating the Scatter PlotConclusion Overview Scatter Plots in […]
September 19, 2020
understand scatter charts

Do You Understand Scatter Charts?

ContentsIntroductionScatter Plots/ChartsReading Scatter ChartsDirectionPatternStrengthOutliersConclusion Introduction Up until recently, Scatter Plots, also known as Scatter Charts or Scatter Graphs seemed like an unnecessary type of chart to […]
September 19, 2020
DAX in power bi - intro to calculated table

Practical Introduction to DAX ( Intro to Calculated Tables)

ContentsWhat you should Know before we beginNames:Caution with NamesPractical Introduction to Calculated TablesCreating Calculated Tables in Power BIHow to create a new Table with DAX.Conclusion What […]
Translate »
Scroll Up