Tag Archives: Power BI

DynamicsCon: Putting The “F-U-N” In “Dynamics User Group” If You Rearrange Some Letters And Add An F

I recently had to change the title of this site and remove the “Microsoft MVP” title; unfortunately I was not re-awarded this year. It felt like one of those detective movie “Turn in your gun and badge!” scenes – only in nerd speak “Turn in your stickers and NDA!”

I’m not sure if I’ll ever get my stickers again, but I do want to continue my passion of making Dynamics and the Power Platform simpler, intuitive, and most importantly fun for new users. For the fun part, my upcoming goal is to entertain by volunteering and presenting for a new User Group event called “DynamicsCon”.

That’s Exciting, Tell Me More!

DynamicsCon. Go look at the site! Looks like a fun time, right?

DynamicsCon will start its life as a virtual event running September 9 – 10 and brings together the finest Dynamics experts from across the lands, and me. You and your organization can attend for the low price of $0.00 – that’s right, FREE KNOWLEDGE.

For this event to be a smashing success, and for me to present to a virtual stadium full of screaming fans, would you take a second and help get this community event rolling?

  1. Register at https://dynamicscon.com/.
  2. Vote for the sessions you want to attend or watch later!
  3. If you want to present, or know someone who does, submit your ideas at https://dynamicscon.com/speakers/.

DynamicsCon content selection is driven by the community – the sessions we submit and vote for are the sessions that will happen.

Shameless Plug Time

I submitted a presentation for your consideration titled “8½ Power BI Concepts I Wish I Knew When I Started”. This presentation is going to be really good; my presentation quality is always proportional to the cleverness of the title. I only need your votes and I can start thinking up the 8½ things I’m going to share!

Please vote for my session here: https://dynamicscon.com/sessions/?search=leichty

And in the spirt of the community freely sharing ideas, please comment below with any Power BI Concepts You Wish You Knew When You Started…

April – September 2019 Release Notes For Dynamics and Powers

Check out the latest features for all your favorite Dynamics and Powers!


Pro tip: The first article in every section contains the Estimated release date. I suggest looking at feature from that article so you also know when to expect them.

For example the F&O article: https://docs.microsoft.com/en-us/business-applications-release-notes/april19/dynamics365-finance-operations/planned-features

PUG Summit | Understanding Time Intelligence with Power BI

Presenter: Dan Edwards

Auto Date Fields

Power BI can create automatic date hierarchies, for report and drill down by Year/Quarter/Month/Day. It’s important to consider whether your data model has more than one fact table with a date attribute. If there are multiple facts, or you have already created a date table, it’s a better to use your own date dimension.

“Don’t use auto date/time” -Dan

I love these types of tips and tricks – here’s how it works, and don’t do it!

Creating a Date Table with DAX

It’s possible to use a DAX expression to create a date table. The initial DAX expression looks like this:

Date = CALENDAR(“1/1/2016”, “12/31/2019”)

Use the DAX expression to create a New table in Power BI.


Then additional columns can be added to the Date dimension table:

Month = MONTH(‘DATE'[Date])


It’s also possible to do concepts like MonthDate where you calculate a Date column with the first day of every month, which can provide flexibility.

MonthDate = DATE( YEAR(‘DATE'[Date]) , MONTH(‘DATE'[Date]) , 1 )


Using an Effective Date

One of the scenarios is a scenario where the user wants to pick the effective date – for example a cutoff date or the last 12 months.

Dan mentioned he has a fairly extensive blog post on how to implement this concept.


Great presentation!

Implement BI With These 394 Simple Steps

There’s a famous Nobel Prize winning study in psychology around Experience versus Confidence that is commonly known as the “Dunning-Kruger” effect. The study showed when we know a little bit about a topic, we initially rate our confidence level extremely high. As we attain intermediate experience, our confidence level dips way down. Then as we actually attain expertise, our confidence goes back up, but never quite as high as it originally was.

Dunning-Kruger Effect

I’ve certainly felt this way in many areas of my work and personal life. One of my hobbies is photography; it seems like many times the more photos I take, the lower my confidence level gets. It’s an odd and frustrating feeling.

2012 vs 2017. Maybe I’m improving?

Hello? The Title of this Post Mentioned BI?

About a year ago I was asked by SAGlobal to head up our Business Intelligence and Reporting group. “Great,” I thought. Grab some data, sprinkle in some Power BI, drill down-through-over-beyond, and let our praises be sung. Confidence level: 100%.

Then that dreaded Experience took over and started to teach me that perhaps there are additional lessons to learn.

Technology Versus Decision Making

Experience taught me that all the pretty graphs, data, and fancy user experiences are simultaneously important and irrelevant. There’s a lot of complexity that can be introduced around methodologies, user stories, maturity models, metrics, technologies, data science, and machine learning.

What really matters is how can businesses make more accurate, faster, and fact-based decisions? In other words, how can BI and Reporting improve the bottom line?

Many times the decision making process is buried in the hearts and minds of the people in the business. Turning soft intuitions and feelings into hard metrics and performance indicators is a process that’s longer term than just developing any single report. The most underrated part of a Business Intelligence solution is extracting the intelligence from the business.

Help Companies Make Better Decisions

Organizations may go through their own Dunning-Kruger lifecycle when it comes to Business Intelligence. Initially they see the latest and greatest tools, and Confidence is at 100%. Experience goes up, and there may be a drop in Confidence around their progress. Over time, key concepts and ideas are visualized in ways used to take a human to analyze and the Confidence goes sky high.

If the decision making process sounds intriguing to you, or fits someone you know, check out our BI Business Analyst job ad on LinkedIn. We’re hiring, and I’m 100% Confident you’ll love it.