• Home
  • Tools
    • Business Ops
    • Themes – New
    • Scrims
    • No Code – Custom Visuals
    • Layouts
    • Custom Visuals Gallery
    • Connections (PBIDS Files)
    • Model.JSON builder
    • ToolBox
    • Lingo
  • Recent
  • Shop
    • Power BI SWAG
    • Scrims
    • Layouts
    • Solutions
    • DAX Games
    • My account
      • Cart
      • Checkout
    • Terms of Use
      • General Privacy Rights
      • California Privacy Rights
      • Copyright DMCA Policy
  • Clothing
  • YouTube
  • More Resources
    • MBAS 2019
    • MBAS 2018
    • Videos
  • About
    • Owners
    • Contributors
News Ticker
  • [ 2021-01-05 ] Power BI End-to-End Architecture Sharing & Administration
  • [ 2020-12-22 ] Phil Seamark on Aggregation Tables Data Preparation Tips
  • [ 2020-12-16 ] Power BI Direct Query Composite Models = Amazing Power BI Developers
  • [ 2020-12-13 ] Power BI Architecture in a Data Solution Articles & Opinions
  • [ 2020-11-18 ] Building a Power BI Admin View using Power BI APIs Power BI Developers
Home2016May

Month: May 2016

CAGR
Report Data Tips

Measures – Dynamic CAGR Calculation in DAX

2016-05-27 Mike Carlo 10

This tutorial walks through calculating a dynamic Compound Annual Growth Rate (CAGR).  By dynamic we mean as you select different items on a bar chart for example the CAGR calculation will update to reveal the […]

Advanced Editor Feature Image
Data Preparation Tips

Query Editor – Editing M Code

2016-05-19 Mike Carlo 2

In this tutorial we’ll learn how to copy and paste queries to and from the Query Editor.  When your working in Power BI Desktop often you will need to share and model the data before […]

Sum Dax Feature
Report Data Tips

Measures – Calculating a Sum

2016-05-07 Mike Carlo 3

Often there are times when you will want to display a totals.  Using measures to calculate a total are extremely easy to use.  The power of using a measure is when you are slicing and […]

Report Data Tips

Measures – Calculating % Change

2016-05-02 Mike Carlo 12

In our last post we built our first measure to make calculated buckets for our data, found here.  For this tutorial we will explore the power making measures using Data Analysis Expressions (DAX). When starting […]

Top Posts

  • Loading Excel Files from Sharepoint
    Loading Excel Files from Sharepoint
  • Dynamic Visuals using Buttons
    Dynamic Visuals using Buttons
  • Icons upon Icons
    Icons upon Icons
  • Measures - Month to Month Percent Change
    Measures - Month to Month Percent Change
  • Measures - Year Over Year Percent Change
    Measures - Year Over Year Percent Change
  • Creating A DAX Calendar
    Creating A DAX Calendar
  • Ranking Values with Measures
    Ranking Values with Measures
  • Loading Data From Folder
    Loading Data From Folder
  • Measures - Dynamic Percent Change - Using DAX
    Measures - Dynamic Percent Change - Using DAX
  • Load Multiple Excel (xls or xlsx) Files
    Load Multiple Excel (xls or xlsx) Files

Recent Posts

  • Power BI End-to-End Architecture
  • Phil Seamark on Aggregation Tables
  • Power BI Direct Query Composite Models = Amazing
  • Power BI Architecture in a Data Solution
  • Building a Power BI Admin View using Power BI APIs
  • Power BI Field Finder V2
  • Mirabile Notitia – Power BI with Harry Potter
  • Milwaukee Brew City PUG – Oct 2020
  • HTML Content Custom Visual
  • Power BI is part of the greater data solution
  • MVPs React October 2020
  • Customize the Default Dataset
  • Power BI Quiz – Themes
  • Milwaukee Brew City PUG – Sept 2020
  • MVPs React September 2020

Subscribe to our mailing list

Ads

Product categories

  • Game (7)
  • Layouts (22)
  • PBIX File (5)
  • Scrims (14)
  • Solution (3)
  • Uncategorized (0)

Tags

Advanced Advanced Editor Advanced Skill Level Bar Chart Beginner Beginner Skill Level Calendar CSV File Custom Layouts Custom Visuals Custom Visuals in Charts Data Modeling Dax DAX Calculate DAX Expressions DiscoverEI Excel Excel File Game Get Data ggplot2 How to Import Data from Excel Layouts mapbox Mapping Maps Measures Microsoft Milwaukee Brew City Monthly Releases MRAN Percent Change Power BI Power BI Desktop Power BI Embedded Power BI Tutorial PUG Query Settings R Slicer Tutorial Tutorials Using Data Models Videos

RSS Feed

  • RSS - Posts
Archives
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
Pages
  • About
    • Contributors
    • Owners
  • Home
  • More Resources
    • MBAS 2018
    • MBAS 2019
  • Recent
  • Shop
    • California Privacy Rights
    • Cart
    • Checkout
    • Copyright DMCA Policy
    • General Privacy Rights
    • My account
    • Terms of Use
  • Tools
    • Layouts
    • Lingo
    • Report Theme Generator V3
    • Scrims
    • Theme Generator
    • ToolBox
  • Top Tutorials
Categories
  • Articles & Opinions
  • Building Reports
  • Data Preparation Tips
  • Data Sources
  • Interesting & Fun Applications
  • News & Events
  • Performance Tips & Tricks
  • Power BI Developers
  • PowerBI.Tips Tools
  • Report Data Tips
  • Report Interactions
  • Report Visualization Tips
  • Sharing & Administration

Copyright © 2021 | MH Magazine WordPress Theme by MH Themes