Creating DAX Measures in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

Continue reading “Creating DAX Measures in Microsoft Power BI”

Adding the Fields to a Visual’s Tooltips in Microsoft Power BI

In this Video, I’ll show you how to add fields to the additional information, called “Tooltips”, in a Microsoft Power BI visual.

In this Video, I’ll show you how to add fields to the additional information, called “Tooltips”, in a Microsoft Power BI visual.

Continue reading “Adding the Fields to a Visual’s Tooltips in Microsoft Power BI”

Adding the Q&A Visual in Microsoft Power BI

In this Video, I’ll add a Q&A Visual to my Microsoft Power BI Desktop Report.  This visual uses Microsoft Bing “Natural Query Language” technology.  This is just a fancy way to say, you ask it a question, and you’ll get an answer back in the form of a visual.

In this Video, I’ll add a Q&A Visual to my Microsoft Power BI Desktop Report.  This visual uses Microsoft Bing “Natural Query Language” technology.  This is just a fancy way to say, you ask it a question, and you’ll get an answer back in the form of a visual.

Continue reading “Adding the Q&A Visual in Microsoft Power BI”

Creating DAX Columns in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a column.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a column.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

Continue reading “Creating DAX Columns in Microsoft Power BI”

Microsoft Excel new Rich Data Types (with Video)

Microsoft Excel Developers have done it again.  They created an amazing new feature called Rich Data Types.  Excel has always been able to recognize Text, Numbers, Errors, etc.  But now?  Now it can recognize Stocks and Geography.  Watch this video to see this cool new feature.

Microsoft Excel Developers have done it again.  They created an amazing new feature called Rich Data Types.  Excel has always been able to recognize Text, Numbers, Errors, etc.  But now?  Now it can recognize Stocks and Geography.  Watch this video to see this cool new feature.

Continue reading “Microsoft Excel new Rich Data Types (with Video)”

Not Your Daddy’s Financial Series

I’m conducting a 2-part series on building and consuming Financial Statement data in Microsoft Power BI called Not your Daddy’s Financials Series.  Feel free to join me!

I’m conducting a 2-part series on building and consuming Financial Statement data in Microsoft Power BI called Not your Daddy’s Financials Series.  Feel free to join me!

Continue reading “Not Your Daddy’s Financial Series”

Using Relative Date Filtering in Microsoft Power BI

 In this video, I demonstrate using Relative Date Filtering in Microsoft Power BI.  My dataset contains unpaid Accounts Payable invoices and their due dates.  I use the Filter options to restrict the visual to display only invoices that are in the next 275 weeks.  My sample data is way out in the future, realistically, you would want to see what’s due this week, month, etc.

In this video, I demonstrate using Relative Date Filtering in Microsoft Power BI.  My dataset contains unpaid Accounts Payable invoices and their due dates.  I use the Filter options to restrict the visual to display only invoices that are in the next 275 weeks.  My sample data is way out in the future, realistically, you would want to see what’s due this week, month, etc.

MBS Podcast: Presenting Convergence… Yeah, you’ll understand after you listen. Podcast 2

Today we’ll be talking about the new Microsoft Business Summit, and whether it really is the return of Convergence.  You’ll also get to listen in on our sharing how we prepare and come up with topics on which to present.

Today we’ll be talking about the new Microsoft Business Summit, and whether it really is the return of Convergence.  You’ll also get to listen in on our sharing how we prepare and come up with topics on which to present.

This podcast was recorded on 4/13/2018.

Listen Here!

Our Sponsor today is PowerGP Online.  Visit their site at PowerGPonline.com

This podcast is the opinions and ideas of three Microsoft MVP’s, who are wrong a lot.