dax
4327 TopicsHelp with DAX
Dear Pros, Need help here I have a monthly recurring charge (MRC) from multiple customers that continues every month until the end of their contracts. I want to calculate the MRC amount for each month. For example, Customer A starts billing in January and pays $100 every month until the contract ends, while Customer B starts billing in March and pays $50 every month until the end of the contract. So I want see how much money we have received every month and from which customers. Something like this Jan - 100 Feb - 100 Mar - 100+50 Apr - 100+50 .... so on Note : I don't have the end of the MRC month date but I have the start of the MRC billing and number of billable months in each year please help with daxSolved101Views1like10CommentsMy 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/,416Views0likes0CommentsPortland 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/5045305Views0likes0CommentsImproving 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.356Views0likes0CommentsBetter DAX
Session Details In this demo-heavy technical session, we’ll look at some less-than-optimal DAX formulas and see how we can improve them. Attendants can expect to take away some tips on writing DAX that they can apply in their own work. Speaker Details Daniil Maslyuk (Microsoft MVP) is an independent business intelligence consultant, trainer, speaker, and book author who specializes in Microsoft Power BI. Daniil blogs at xxlbi.com and tweets as dmaslyuk215Views0likes0CommentsQ&A session - My Power BI report is slow, what should I do?
This will be a live Q&A session - A private link to the recorded video with the same topic from SQLBI will be shared a few days before the event on the Persian Power BI LinkedIn page (https://bit.ly/32tGkif). After that, you can watch the video and start submitting your questions for this live Q&A session. To do so, prepare related questions and post them on the pigeonhole page set up for this event. Open https://pigeonhole.at/ and use PERSIAN as a password to submit your questions. More details about the video and Q&A session: https://www.sqlbi.com/blog/marco/2021/02/05/testing-sqlbi-live-qa/ 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞: English 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL176Views0likes0CommentsPower BI Johannesburg User Group Meeting
The third PUG event for the year will be held on Thursday the 26 th of May 2022 starting at 17h00 sharp. This event will revert back to an online event only given the rising COVID numbers. The Agenda for the evening is as follows: 1. BI News by Siya Zungu 2. BI Flashes: Hitting BI User Adoption Goals by Erika Scholtz 3. Episode 3 of the Brick-by-Brick series: The Wish - Data Modelling in PBI, starting with Business Analysis by Tshego Thejane Please RSVP through this link. Note: - The online meeting link will be provided two days prior to the event.Why Do My DAX Formulas Return Wrong Results?
Why Do My DAX Formulas Return Wrong Results? This session will focus on some of the common DAX formula mistakes beginners make when building measures and calculated columns. I will share examples and solutions that I have encountered in helping members of the Power BI community. Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Fowmy Abdulmuttalib: Fowmy is the founder of ExcelFort Consulting and Training. He is a Microsoft Certified Data Analyst, Power BI SuperUser and an experienced Finance Professional with skills in Business Analytics and Financial Reporting. This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat. Contact with Fowmy Abdulmuttalib: LinkedIn: https://www.linkedin.com/in/fowmy/ Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.119Views0likes0CommentsUsing QGIS to build a layer for Power BI map visuals
Using QGIS to build a layer for Power BI map visuals In this session, using QGIS to build a (background) layer for Power BI map visuals, probably a Thiessen Voronoi polygon and an isochrone (distance rings). Azerbaijan data set will be used to make it more familiar for the viewers. Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Paul Lucassen: Experienced Supply Chain professional with strong analytical, strategic and social skills. Experience as Project Director and General Manager Wide-ranging knowledge and experience in European Distribution, Service Logistics, Service Logistics and Supply Chain Solutions. Experienced in developing (in-night) Distribution Networks in Europe Consultancy activities focus on: Supply chain modelling applying GIS software. Greenfield analysis and Cluster analysis (www.lucassen-consulting.nl) Network analysis and restructuring Training in GIS application and Excel modelling/dashboards This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat. Contact with Paul Lucassen: LinkedIn: https://www.linkedin.com/in/paullucassen/ Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.5KViews0likes1Comment