dax

From time to time, I stumble upon data that have a starting and an ending time. It could be opportunities in a CRM system, time between an email arrived in you mailbox until it was responded to or a …

This video shows how to create a like for like comparison in DAX comparing equivalent periods, and how to correctly implement a Boolean condition in a calcu

Learn how to fetch the latest status in a period through an HR Power BI design pattern showing the latest position to date.

Calculation Groups in Power BI can be amazing! Patrick shows you how you can create these common patterns with just one click using Tabular Editor. Blog: https://www.esbrina-ba.com/time-intelligence-the-smart-way/ Calculation Groups: https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions Tabular Editor: https://tabulareditor.com

Looking at new ways of Expressing Date and Time Values in Power BI DAX in order to more quickly do analysis with Date and Time.

This article describes how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases. When

Learn how to add a year-month combination into the Power BI report using DAX and sort it correctly using an example.

To understand how a filter can affect performance, first we need to understand what a filter is. A filter is a temporary table that is created on demand, held in memory, and then used as a reference for the function being filtered. The rows of the temporary filter table are all DISTINCT. This is because […]

Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main r…

Recently while working on a consulting project, I came across a very interesting problem. It was interesting enough, that I am passing it on to you.   Consider this Employee Data The data represents an employee role for each month, since the employee’s joining date. Each row means 1 employee assigned to a certain role [...]

Version 1.1 of the #exportreportobjects script has been released! With this version, the script will identify unused objects (measures/columns within your...

Sometimes you want to highlight the lowest value in a Power BI visual. First you need to find it! Then you can highlight it. What if you want to ANIMATE it? Patrick shows you how to do just that! ALLSELECTED() article: https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/

Enhance your performance testing and measure tuning skills by learning DAX as a query language.

It is possible to filter a matrix by a measure, but may lead to unexpected results. See one such case and a possible workaround with a calculation group.

In DAX, optimizations and data types do not always play nice and can leave you dealing with surprises. In this short article, we see an example of how mixin

Microsoft Hates Greg. Contribute to gdeckler/MicrosoftHatesGregsQuickMeasures development by creating an account on GitHub.

Microsoft Hates Greg's Quick Measures Image concept and credit: Rocket Deckler Introduction Today I am announcing the availability of a new External Tool for Power BI Desktop, "Microsoft Hates Greg's Quick Measures" or MSHGQM for short. This tool more than doubles the number of Quick Measures avail...

This is where you describe the app...

As an extension to my recent article on base conversions in DAX, I thought I’d show how these conversion calculations can be used to help you perform bitwise calculations in DAX. At present, there …

I recently came across a real head-scratcher of a question on Stack Overflow. This post is an expansion of the answer I gave there. The goal is to provide a useful model to understand filter context. This is foundational knowledge for any aspiring DAXter (DAXist?) and is required to understand CALCULATE properly.

DAX is simple, but it is not easy. Watch the video to learn why, and remember: Practice. The. Fundamentals.

Video by: Reid Havens Learn how to add [DAX] measure driven values the y-axis constant lines . Allow us to essentially recreate multiple analytics lines that can be configurable by user slicer selections in Power BI. RELATED CONTENT 🔗 Positive/Negative Line Colors

Let’s say you are building a dashboard for the Sales team and have the following requirements: Each sales person should have access to only their territory – Ok this is easy enough. We …

Shared via Flipboard

DAX generator is a component of Power BI Sidetools able to create complex DAX expressions within your model. Once you built or found the appropriate template,

Warning : this documentation may mention some features under development which will appear in short term.

#powerbi #MSPowerBI

The quick measure calculates the Pearson correlation coefficient between two measures within the category.   NAME: Correlation coefficient   DESCRIPTION: Calculate the Pearson correlation coefficient between two measures within the category   PARAMETERS: Name: Category Tooltip: The category in which...