• Home
  • Tools
    • Business Ops
    • Themes – New
    • Scrims
    • No Code – Custom Visuals
    • Layouts
    • Custom Visuals Gallery
    • Connections (PBIDS Files)
    • Model.JSON builder
    • 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
  • Podcast
  • About
    • Owners
    • Contributors
  • Training
News Ticker
  • [ 2022-11-03 ] Welcome to Community Jam Articles & Opinions
  • [ 2022-10-12 ] Live AMA with Marco Russo & Alberto Ferrari News & Events
  • [ 2022-09-20 ] Super Fast Data Loads to Prod Sharing & Administration
  • [ 2022-05-06 ] Power BI Hack: Download Report Authored in Browser as PBIX Sharing & Administration
  • [ 2022-04-30 ] Power BI Support Channel: Microsoft Teams Tips Sharing & Administration
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 […]

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 © 2023 | MH Magazine WordPress Theme by MH Themes