Showing working day no instead of calendar
Hello, i am facing a challenge where i want to have a bar chart showing daily invoiced sales, but instead of showing calendat day no number on x-axis i want to replace it with working day no. Data model setup: Base model: Tabular (storage mode: mixed) tables and dimensions used: 'Calendar'[ID] - linked to transaction table through a many to one relationship 'Calendar'[day no] - this is what i currently use on my x-axis. This is simply showing day number 1-30 depending on the selected fiscal year and fiscal month 'Calendar'[Fiscal Year] - used in dropdown to filter on fiscal year. runs from 1 july - 30 june 'Calendar'[Fiscal Month] - used in dropdown to filter on fiscal month. runs from 1 july - 30 june 'Global Measures'[Invoiced Amount] Requirements: Create a field to the calendar table return Working day no depending on the selected fiscal year and month. Working day counts as monday-friday, weekends is NOT a working day. Also public holidays should also not be taken into account. Working day should start counting from the first weekday of the filtered month and start over when a new month begins. Ideally, when using the field on the visual, weekends should be blank. I have tried to illustrate my idea through the snapshot below. The grey bars represent saturday and sunday to clearly distinct weekdays and weekends. So far i havent been able to find a working solution, so i am trying my luck making a post here. If there is any information needed regarding the data model or relationships etc. i will try to elaborate, just let me know.Help! explain this measure and why it isn't working consistently!!
I have a report that someone else made and they are not seeing some data show in the visuals that they would expect to see. After investigating I found out that the measures are behaving strangely. Basically there are 3 measures. One determines if there are any items on a SalesOrder that have a synthesisDepartment of "LEU Main - Tubes" : HasLEUMainTubes = VAR CurrentSalesOrder = MAX('vwOperationsBacklog'[SalesOrder]) RETURN CALCULATE ( COUNTROWS ( 'vwOperationsBacklog' ), 'vwOperationsBacklog'[SalesOrder] = CurrentSalesOrder, 'vwOperationsBacklog'[SynthesisDepartment] = "LEU Main - Tubes" ) One determines if there are any items on a SalesOrder that have a synthesisDepartment of "LEU Platinum" : HasLEUPlatinum = VAR CurrentSalesOrder = MAX('vwOperationsBacklog'[SalesOrder]) RETURN CALCULATE ( COUNTROWS ( 'vwOperationsBacklog' ), 'vwOperationsBacklog'[SalesOrder] = CurrentSalesOrder, 'vwOperationsBacklog'[SynthesisDepartment] = "LEU Platinum" ) And the third measure determines if the SalesOrder has items from both departments: HasBothLEUMainTubesAndPlatinum =IF ( [HasLEUMainTubes] > 0 && [HasLEUPlatinum] > 0, 1, 0) The visual is a table that displays a list of SalesOrders that have both Main and Platinum items. However, the users only want to see $ values and specific products that are from Main and have applied a visual level filter of Synthesis Department = "LEU Main - Tubes". Here is the issue: In most cases, this works out fine. Example order 9558544 which has 8 items in each of the two departments shows up in my main visual with only $ associated to the Main department. BUT example order 21583399 does NOT show up in the table even though it has 2 Platinum items and 3 Main items. I created a quick look at these 2 orders and the results of the 3 measures below (separated by Synth Dept) As soon as I apply a visual level filter to that same table (setting Dept = Leu Main - Tubes), this is the result: WHY DOES ONE ORDER WORK DIFFERENTLY FROM THE OTHER????? I also know I could probably come up with a better way of doing this (I did not develop these measures, a user did) but I ultimately want to know why it functions like this.Power B(A)I – AI-driven Reporting with MCP, Custom AI Skills & Power BI Bridge
🚨 Join our upcoming online meetup! Power B(A)I: AI-driven Reporting with MCP, Custom AI Skills & Power BI Bridge We are delighted to welcome Karin Szilágyi, a DataViz finalist, for a practical session exploring how AI is changing Power BI reporting. During this session, Karin will demonstrate how MCP, custom AI skills and Power BI Bridge can help you create smarter, more efficient and AI-powered reporting workflows. 📅 Friday, 25 September 2026 🕗 8:00 PM Baku time 🌐 Online event Register here: https://www.meetup.com/azdata-aicommunity/events/315837519/ Join us to discover new possibilities at the intersection of Power BI, artificial intelligence and data visualisation.
My Power BI report is slow – What should I do? With Marco Russo
Description: Join our Microsoft Power BI - UK User Group for our monthly webinar in association with Onyx Data (onyxdata.co.uk). This month we are excited to announce our host Leon Gordon will be introducing the BI God Marco Russo for a Q&A session. Please watch this exclusive YouTube video - https://youtu.be/NzI0lXT_6U4 and provide the questions that you would like to ask Marco in the event discussion section BEFORE the event. My Power BI report is slow: what should I do? You created a wonderful Power BI report, but you wait too much time when you open it. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance? This session will guide you in analyzing the possible reasons for a slow BI report. Using Power BI Performance Analyzer and DAX Studio, you will determine whether you should change the report layout or if there is something in DAX formulas or the data model is responsible for the slow response. At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report so that you will focus your attention on the biggest issue. Host bio- Marco is a business intelligence consultant and mentor. He first started working on Analysis Services in 1998, back when Analysis Services was known as OLAP Services. A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits. He also enjoys delivering evening sessions at local user groups during his trips. When he is not working, you can find Marco fine tuning his expertise of Neapolitan pizza or test driving electric cars. EVENT ID: 8193 Date and Time: Thursday 6th May - 18:00 - 19:00 BST Speaker: Marco Russo Speaker Bio: Marco is a business intelligence consultant and mentor. He first started working on Analysis Services in 1998, back when Analysis Services was known as OLAP Services. A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits. He also enjoys delivering evening sessions at local user groups during his trips. When he is not working, you can find Marco fine tuning his expertise of Neapolitan pizza or test driving electric cars. Speaker LinkedIn: https://www.linkedin.com/in/sqlbi/ https://www.linkedin.com/in/leon-gordon/,Portland Power BI User Group Virtual Meetup
Description: ANGELA HENRY (Blue Granite, Microsoft MVP) - Understanding DAX – It’s All About the Context | How many times have you created a Power BI report and gotten an unexpected or inconsistent result, then spent an absurd amount of time trying to figure where the result came from? This happens with almost everyone when they start writing DAX. The key to understanding DAX is context, evaluation context. This session won’t provide the magic bullet to becoming a master at DAX, but will help you understand evaluation context, so the next time you create a measure, the result will be not only consistent, but expected. ID: 10477 Speaker Bio: Learn more about Angela and her featured presentations on her blog: https://sqlswimmer.com/about/ Speaker LinkedIn and Community Profile: https://www.linkedin.com/in/angelahenrydba/ https://community.powerbi.com/t5/user/viewprofilepage/user-id/5045Improving your DAX skills with DAX.do
This advanced session focuses on using the DAX.do web site, developed by SQLBI, to improve your DAX knowledge. You will learn about the user interface, the data models, and sharing queries. Next, we will write queries using common DAX functions. You will want to bring your internet connected device to practice writing these queries during the session in your favorite browser. It is recommended that attendees have basic DAX skills/knowledge will get the most out of the session. Kevin Arnold is the Director of Architecture and Managing Partner at Expert Analytics, overseeing software management methodologies, deployment strategy, and optimal data architectures for clients. He is a senior data architect with over 20 years’ experience, including at large-cap consultancies Price Waterhouse and EDS. He has spoken at numerous conferences and user groups, including the DAMA International and CA World Conferences. His areas of interest include Power BI, Analysis Services, SQL Server, PowerShell, DevOps, Azure, and Power Query. His work focus within the Microsoft BI Stack has been on Analysis Services, Power BI and Azure SQL Server. He is a co-leader and frequent presenter for the Dallas/Fort Worth Power BI User Group. He actively promotes worldwide user groups by sharing the Power BI Meetup Report.
