Power BI

At the end of 2020, I worked on a bunch of new features for SP Formatter. SP Formatter is a web extension (supports Chrome and Edge), which transforms the out-of-the-box SharePoint Column (View) Formatting experience and makes JSON editing a lot more... [Click to read more]

[vc_row][vc_column width="1/1"][vc_single_image media="88046" media_width_percent="100"][vc_column_text]Watch the video above to learn how to create a Simple Moving Average (SMA) calculation in a […]

Certification is essential for Data Analysts to increase knowledge and proficiency of using Power BI as well as to demonstrate and prove it. Getting Certified Data Analyst Certification requires a very wide and advanced set of skills and efforts.There are many sources and materials which you can use in order to prepare for this exam, here are some tips from our team.

This set includes 2000 free Power Apps icons in over 30 different colors from the Fluent Design System. All available icons can be found here.

After the prolific response we have been getting from everyone on our productivity apps for Dynamics 365 CRM and our recently concluded webinar series including sessions on visual tools like Kanban …

See Vertipaq Analyzer stats in Tabular Editor and create Best Practice rules around them.

Want to improve the performance and design of your Power BI model? Run these newly published rules against your model to quickly identify areas of improvement!

One of the most exciting things about being a Power BI service administrator is watching what's going on inside the service. This blog starts a series of articles on how to create your own Service Monitoring application using Power BI.

There is just one thing that is more satisfying than writing complex DAX measures, and that is avoiding complex DAX due to smart data modeling.

I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.

Query folding is a key capability in Power Query. In short, query folding is the process by which the Power Query mashup engine takes the steps defined in the Power Query editor and translates them…

This article shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all

This article describes the syntax and the use cases of the DEFINE COLUMN statement in DAX. Introduced in December 2020, the DEFINE COLUMN statement lets you

How many times did you ask a technical question, to be met with a laconic “it depends”? Or worse, for your question to be totally ignored? This is so ty

“DirectQuery for Power BI datasets and Analysis Services” is the name of a new feature released in December 2020 that we simply call… R

This article describes the syntax and the use cases of the DEFINE TABLE statement in DAX. Introduced in December 2020, the DEFINE TABLE statement lets you d

I found this interesting chart on Datawrapper.de and it made me think about how (and whether) my chart selections also changed over time. (Datawrapper is a pretty cool tool that allows users to upl…

I use Sales data a lot in my tutorials and usually the Sales Fact table will have the following fields in it: DateProductRevenueUnits Along with a bunch of other stuff…. Now, it is actually very co…

If you are looking to challenge your DAX skills while trying to figure out how to calculate a Cumulative Discount (or a Cumulative Commission) then this tutorial is for you. A Cumulative discount i…

Unfortunately, life is hard and in BI world we are guaranteed to fail with our Data Persuasion every now and then. Having failed with my BI presentations many a time, I decided to write this articl…