Power BI

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...

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...

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...

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 …

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', ...

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.

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

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

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 …

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.

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…

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

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]...

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...

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

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...

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 ...

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...

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…

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…

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…

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…

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 part 1 of this tutorial, I illustrated how to include more than one aggregation and cu...

Expanded tables are the core of DAX; understanding how they work is of paramount importance. This article provides a theoretical foundation of what expanded