Guy(s) in a Cube present | Power BI tips to take performance to the next level!
For the 1st Health & Life Sciences Power BI User Group event, Guy(s) in a Cube will be sharing tips and tricks on how to boost performance. Want to make your Power BI reports perform at insane amazing speeds? We will explore some practical and common performance problems that customers encounter when using Power BI. From report design to your data, we will cover different aspects of Power BI to get your report working at the level that you expect. There are different settings and techniques you can use to maximize your data and reports within Power BI. Adam Saxton is just a guy in a cube doing the work! He is on the Power BI CAT team at Microsoft working with customers to help adopt Power BI. He is based in Texas and started with Microsoft supporting SQL Server connectivity and Reporting Services in 2005. Adam has worked with Power BI since the beginning, on the support side and with documentation. In addition, he produces weekly videos for his Guy in a Cube YouTube channel. LinkedIn Patrick LeBlanc is currently a Principal Program Manager at Microsoft and a contributing partner to Guy in a Cube. Along with his 15+ years' experience in IT, he holds a Master of Science degree from Louisiana State University. He is the author and co-author of five SQL Server books. Prior to joining Microsoft, he was awarded Microsoft MVP for his contributions to the community. Patrick is a regular speaker at many SQL Server Conferences and Community events. LinkedInTips for Defining Custom Functions in Power Query
Despite the wide variety of functions available in Power Query, sometimes it is necessary to define new custom functions for specific needs, especially in complex data cleansing processes. Online training enables you to become familiar with how to create functions that precisely match your specific conditions and requirements. Defining these specialized functions helps you to clean and prepare your data in a much more accurate and flexible manner, facilitating the optimization of your workflows. ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐๐ก๐๐๐ง๐๐ข ๐พ๐๐๐ฃ๐ฃ๐๐ก: https://t.me/PersianPBIUG ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RL Language: Persian - Persian-Farsi
Group values
Hi everyone, I would like to create a regroupment of KPI in different "bloc" for cleaning the analyse of dashboard. I mean, one bloc for - "N year" with KPI "Semaine" + " N date" - On other "N-1 year" with "MEC N-1" + "N-1 date" etc. - Etc. The aim is to compartiment for a good view. I tried many ways but it didn't work.. Your help is precious. Thank you in advance
Last non blank month with context issues
Hi! I have issue with below measure. It works when there are no additional columns that would "break down" the Actual/Plan/Forecast measure. But as soon as there is such column together in the matrix with below, the values are wrong. I've noticed it's because the NO(ISBLANK()) gets evaluated separately for every "category" it's broken down into, instead on the whole measure. Below is the representation what the measure does. . Year Period Job Category Raw Amount LastNonBlankPeriod 2023 11 Finance 5 11 2023 11 Sales 10 12 2023 12 Finance BLANK() 11 2023 12 Sales 11 12 Because Finance is BLANK in 2023, it takes period 11 into account for this specific category. Where my goal is it should always be 12 in below case as there are some values for period 12. And my values from below measure, if I remove period split will be: Finance 5, Sales 11. Instead of Finance 0, Sales 11 How can I fix the measure? Headcount Switch Yearly = SUMX( VALUES('X_Calendar Period'[F_YEAR]), VAR CurrentYear = 'X_Calendar Period'[F_YEAR] VAR LastActualsPeriod = CALCULATE( MAX('X_Calendar Period'[F_YEAR_MONTH_NO]), FILTER( ALL('X_Calendar Period'), 'X_Calendar Period'[F_YEAR] = CurrentYear && NOT(ISBLANK([Headcount By Heads])) ) ) VAR LastForecastPeriod = CALCULATE( MAX('X_Calendar Period'[F_YEAR_MONTH_NO]), FILTER( ALL('X_Calendar Period'), 'X_Calendar Period'[F_YEAR] = CurrentYear && NOT(ISBLANK([FCST Headcount By Heads])) ) ) VAR LastPlanPeriod = CALCULATE( MAX('X_Calendar Period'[F_YEAR_MONTH_NO]), FILTER( ALL('X_Calendar Period'), 'X_Calendar Period'[F_YEAR] = CurrentYear && NOT(ISBLANK([PLAN Headcount By Heads])) ) ) RETURN SWITCH( TRUE(), CurrentYear <= [Actuals Year], CALCULATE([Headcount By Heads], 'X_Calendar Period'[F_YEAR_MONTH_NO] = LastActualsPeriod), CurrentYear = [Forecast Year], CALCULATE([FCST Headcount By Heads], 'X_Calendar Period'[F_YEAR_MONTH_NO] = LastForecastPeriod), CurrentYear = [Plan Year], CALCULATE([PLAN Headcount By Heads], 'X_Calendar Period'[F_YEAR_MONTH_NO] = LastPlanPeriod), BLANK() ) )Filter context doesnt apply with custom date slicer
Hello everyone, I have implemented a new Date Picker following this quick tutorial in order to extend the possibility of filtering my data. However, I am struggling with calculating measures for the previous period selected in my Date Picker. First, here is how my model is built: here is the measure I want to calculate in a modified filter context: here is a quick example of how my Dateslicer selection is built: I then put the "Period" column in a slicer in order to select the "Last calendar week" option and then filter the Datedim table in the corresponding manner and to replace the classic between date slicer. However, since I have implemented this configuration, I am not able to calculate the previous_period_measure with this original formula (startOfPrevPeriod and endOfPrevPeriod being out of the data range filtered with the slicer) : Previously, without the DateSlicerSelection, the DateDim[FullDateAlternateKey] was in a between date slicer and everything was working fine. Despite the fact that I have absolutely no idea of how to fix it, I have made few observations: I am able to get the very first Date of my DimDate table even with it is filtered with he following formula : Modifying my measure calculation with the following formula, I got the result for the current period selection and not the previous one: Please, does someone has an idea on how to fix this problem ? Best Regards, Melvin
