My name is Mathew Herring Jack, and I am a member of Traditional Excel Users Anonymous. As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagn…

Last week, I had the pleasure of recording some video with Bert Wagner about Power BI. In the video, I got to use one of my favorite analogies for M versus DAX: Are you chopping broccoli or planning a…

Got a DAX question recently that I solved using variables. When I walked them through the solution someone exclaimed “I didn’t know you can do this with variables!”. Variables are a great way…

I often have inputs I know today and want to “run them out” into the future applying certain parameters along the way to create a projection. I’m in finance, so my needs will almost always have a fina…

Given a table of data called "Students" such as: Teacher Student Teacher A Student 1 Teacher A Student 2 Teacher A Student 3 Teacher A Student 4 Teacher B Student 1 Teacher B Student 5 Teacher B Student 7 Teacher B Student 8 Teacher C Student 3 Teacher C Student 4 Teacher C Student 7 Teacher C Stu...

Hi Guys, I've Created a Graph in power bi that has the values on the y-axis, and the month number on the x-axis, something that looks similar to the below sample chart. Basically, what I need to do, is to find the "Prediction Grade" that most closely resembles the "Actual Value", and have the ...

Hi, I'm gaining a better appreciate for DAX and context. There is one topic that still has me a little puzzled. Appreciate some help to reaffirm my understanding (or corrections are welcome) and help with the bits I don't quite get yet... I think I understand what is happening in my calculate...

This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand perform

From Wikipedia on Covariance: https://en.wikipedia.org/wiki/Covariance In probability theory and statistics, covariance is a measure of the joint variability of two random variables.[1] If the greater values of one variable mainly correspond with the greater values of the other variable, and the sam...

Hi This calculated table might be close. Table = VAR DistinctValues = SUMMARIZECOLUMNS('Table1'[Case],'Table1'[Team]) VAR Final = SUMMARIZECOLUMNS('Table1'[Case]) RETURN ADDCOLUMNS( Final , "Group" , CONCATENATEX( FILTER(DistinctValues,[Case]...

Try this Column Max Date = VAR temp = { Table1[A Approved], Table1[B Approved], Table1[C Approved], Table1[D Approved] } RETURN MAXX ( temp, [Value] )

Another Friday, another tip. Power BI has undergone a lot of innovative updates over the years, but my favorite one has been a combination of the cross-filtering & highlighting capabiliti…

This post describes approaches how to virtual relationships between tables can be established using the DAX function TREATAS() and also approaches how to create physical relationships instead.

Got an interesting question recently where someone wanted to be able to switch the relationships automatically based on which slicer was selected. Take the following example: Here we have the same …

Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to se

Yes, I have some Mode measures in the Quick Measures Gallery: https://community.powerbi.com/t5/Quick-Measures-Gallery/Mode-Single-Column/m-p/359150 https://community.powerbi.com/t5/Quick-Measures-Gallery/Mode-Multiple-Columns/m-p/359148

Hi , To achieve your requirement, you can try a measure with following expression: SLA % = CALCULATE ( COUNT ( SLA[SLA] ), FILTER ( SLA, SLA[SLA] = "Breached" ) ) / CALCULATE ( COUNT ( SLA[SLA] ), FILTER ( SLA, SLA[SLA] "No Target" ) ) Thanks, Xi Jin.

Give this a shot EHT = VAR myupper = [upper] VAR mylower = [lower] RETURN AVERAGEX ( VALUES ( 'STA Core'[Total TouchTime for the record] ), CALCULATE ( AVERAGE ( 'STA Core'[Total TouchTime for the record] ), FILTER ( 'STA Core', ...

It is Friday, and I thought of writing a quick tip on how you can use the same date dimension for displaying the last N months (say, in a bar chart) and the data for selected month (say, in a card …

This multi-part tutorial blog is geared to help BI Analysts create versatile Scorecards with KPIs as well as to facilitate the business reporting transition from Excel, SSRS or other apps to Power BI Desktop. In this initial installment, I will illustrate how to include more than one aggregation a...

In this post I am going to demonstrate how to create a Dynamic TopN slicer using a What-If Parameter. This will allow your user to simply use the Slicer/Slider to view the TopN values and as a bonus if the user slides it to zero, it will display everything! Who doesn't like something that is easy to...

Recreates the NETWORKDAYS function from Excel with some bonus measures and one that needs fixed or demonstrates a bug/documentation glitch. NetWorkDays calculates the number of days between two dates sans weekends. NetWorkDays = VAR Calendar1 = CALENDAR(MAX(NetWorkDays[created date]),MAX(NetWor...

Have you ever wanted to create automatic forecasts based on historical information? In the past, this was relatively difficult to do using tools like Excel but I’m going to show you in this video t…

, Drag [State] from the calculated table to Axis and measures below to Value. Measure = VAR s = SELECTEDVALUE ( 'Table'[State] ) RETURN IF ( s = "Total", SUM ( ValueTable[Regular jobs] ), CALCULATE ( SUM ( ValueTable[Regular jobs] ), FactTable[State] = s ) ) Mea...

In today’s post, I am sharing a follow-up to my webinar, that will allow you to refresh the queries, and enjoy the support of scheduled refresh on Power BI service. During the webinar (you can watch it here, if you missed it), I created a custom function that paginates over multiple pages, and was asked …

This quick measure returns the selected date range formatted in accordance with the Wikipedia Manual of Style. The date format can be customized by changing the parameters listed below. NAME: Date range DESCRIPTION: Write out the selected date range. PARAMETERS: Name: Date Tooltip: Calendar ...

Hi I've added in the additional checks for those columns (highligted the changes in red-bold) Parallel = VAR MyDate = DATE('Table'[year],'Table'[month],1) VAR SumOfMonthLastYear = SUMX( FILTER( 'Table1', 'Table'[year] = EARLIER('Table'[year]) - 1 && ...