Power BI

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 1: Getting Started with PowerPivot and DAX

  • Stairway Step

Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment.

5 (1)

You rated this post out of 5. Change rating

2022-04-04 (first published: )

34,095 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI

  • Stairway

Data Analysis Expressions (DAX) can be used in formulas or expressions to calculate and return information from data already in our Power BI models. This Stairway series serves as a progressive introduction to DAX within the context of Power BI, examining the functions, operators and values involved, and examining their operation in practice examples. As a part of introducing DAX functions and overall capabilities, the Levels of the series will also offer a wealth of practical exposure to Power BI features as a part of putting DAX to work in our data models and visualizations.

3.8 (5)

You rated this post out of 5. Change rating

2022-04-04 (first published: )

12,472 reads

Technical Article

RE: SQL 2k - Physical Data Structure : PFS+GAM+SGAM+IAM

  • Reply

I hope it is not too late for you. Even if you have the physical data structure on the disk, it is far from taking conclusions whether the situation is good or bad. I am not an SQL expert. My main area is External Fragmentation. I am exploring into Internal Fragmentation, and lookong for a […]

2005-05-26

Technical Article

DTS error executing from Stored Procedure

  • Topic

When I call my DTS package from a stored procedure by: exec master.dbo.xp_cmdshell 'dtsrun /S ntserver5 /U username /P password /N "New Package"' I get the following error: Error string: The Microsoft Jet database engine could not find the object 'jungtran2'. Make sure the object exists and that you spell its name and the path […]

2005-05-24

5 reads

Technical Article

RE: intersting sql puzzle

  • Reply

Here is my solution: SELECT am.antim_id AS antim_id, am.anitm_name AS antim_name FROM (SELECT antim_id, COUNT(dc.missile_id) AS num_missiles FROM (SELECT missile_id FROM (SELECT spcid FROM SPECIES WHERE (spcname = ?)) AS s INNER JOIN ALIEN_CAPABILITY AS ac ON ac.spcid = s.spcid ) AS sm1 INNER JOIN DEFUSE_CAPABILITY AS dc ON dc.missile_id = sm1.missile_id GROUP BY antim_id […]

2005-05-11

Technical Article

RE: Is This possible to do ?

  • Reply

Well I finally got it to work with the help of a co-worker...here is the code  previous_discharge_date  = (SELECT MAX(ISNULL(referral_ref.dischargedate, '')) as previous_discharge_date     FROM      referral as referral_ref     WHERE      referral_ref.dischargedate  <>'2078-12-31 00:00:00'      AND referral.memid   = referral_ref.memid), I was making it way more complex than it needed to be... Thanks to everyone for the help Leeland

You rated this post out of 5. Change rating

2005-04-22

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers