modelling
4 TopicsPower BI Brussels @ Syntra Brussel - Mezure, Tour & Taxis
Power BI Brussels is brought to life to empower every (aspiring) data professional with a community to grow Power BI expertise in a vibrant atmosphere. Agenda 17:30 – 18:15: Welcome with drinks & sandwiches 18:15 – 19:05: Session 1: Port Of Antwerp-Bruges: Navigating towards Data Democratization – Jan Meskens 19:05 – 19:30: Break 19:30 – 20:20: Session 2: Power BI Dataset Checklist - Kurt Buhler 20:20 – … : Networking Location Mezure Tour & Taxis - Royal Depot Havenlaan 86C (box 209) 1000 Brussels Parking under the main building. Check-in at the reception desk of Syntra Brussel/Mezure on the ground floor. SUBSCRIBE ONLY USING THE LINK BELOW https://forms.office.com/e/sfu8JjJDwT Detailed session info: Title: Port Of Antwerp-Bruges: Navigating towards Data Democratization Presenter: Jan Meskens Ref: https://www.linkedin.com/in/janmeskens/ Abstract: Data democratization is an essential step to becoming a data-driven organization. It envisions data accessibility for all employees and relevant stakeholders regardless of their technical background. This talk shows how Port Of Antwerp-Bruges floats towards data democratization. We give practical examples by focusing on four topics: 1. People - employees and stakeholders stepping on board of a data-centric organization 2. Processes - helping to manage data in environments where almost everyone starts to work with data. 3. Tools - diversified data products like Power BI, an in-house built Digital Twin, or a Geographic Information System helps people with different backgrounds and different purposes to work with data. 4. Data - combining your data with relevant open data to empower people in drawing the right insights using their tools. Title: Power BI Dataset Checklist Presenter: Kurt Buhler Ref: www.data-goblins.com/checklists Abstract: We want to create good Power BI datasets, but what does that mean? There’s so much to consider, so how can we be sure that we’ve done the right things? What might we still do to ensure our datasets deliver business value? In this session, we walk through selected items in the ‘Dataset Checklist’, looking at what’s important when creating a typical Power BI Dataset, end-to-end. From the design to building the different parts – Power Query, data model & DAX – as well as handover, documentation & training, this session will give you an overview of key considerations both before you publish & afterwards.992Views0likes0CommentsData Analytic Group - Global Fabric Data Days PL-300: Power BI
Join the Data Analytic Group (DAG) for a full-day, structured study group designed to help you prepare for the PL-300: Microsoft Power BI Data Analyst certification exam. Learn directly from experienced community speakers across five focused sessions covering every major exam domain — from foundational concepts to final exam-day tips. Agenda (IST): TimeSessionTopicSpeaker 09:00 – 10:00 AM Session 1 PL-300 and Power BI Overview Suparna Babu 10:00 – 11:00 AM Session 2 Design and Implement a Data Model Amit Chandak 11:00 – 12:00 PM Session 3 Design Power BI Reports Aadil Latif 12:00 – 01:00 PM Session 4 Create and Manage Workspaces and Assets Dr. S. Gomathi 01:00 – 01:30 PM Session 5 Prepare for Exam Day and Open Q&A Juluri Shashi Who should attend: Anyone preparing for the PL-300 certification, Power BI developers, data analysts, and community members looking to strengthen their fundamentals. Format: Live sessions with practical walkthroughs, real exam-style discussion, and open Q&A with each speaker. Come with your questions and leave exam-ready! Organizers: Rajendra Ongole, Koundinya Lanka,Shashi,Navya K Team: Charitha Reddy, Meghana,Sreekar T 𝑹𝒆𝒈𝒊𝒔𝒕𝒆𝒓 𝒂𝒕 𝑴𝒆𝒆𝒕𝒖𝒑: https://www.meetup.com/dataanalyticgroup/ 𝑱𝒐𝒊𝒏 𝒕𝒉𝒆 𝑾𝒉𝒂𝒕𝒔𝑨𝒑𝒑 𝑮𝒓𝒐𝒖𝒑: https://chat.whatsapp.com/CkMRYzyoKSNKbXUs2IN2MU 𝑱𝒐𝒊𝒏 𝒕𝒉𝒆 𝑾𝒉𝒂𝒕𝒔𝑨𝒑𝒑 𝑪𝒉𝒂𝒏𝒏𝒆𝒍 𝑳𝒊𝒏𝒌:https://whatsapp.com/channel/0029VaBgfAwDOQIeuTjGbF3u YouTube channel: https://www.youtube.com/@Dataanalyticgroup 𝑱𝒐𝒊𝒏 𝒖𝒔 𝒐𝒏 𝑭𝒂𝒃𝒓𝒊𝒄 𝑪𝒐𝒎𝒎𝒖𝒏𝒊𝒕𝒚 : https://community.fabric.microsoft.com/t5/Data-Analytic-Group/gh-p/DataAnalyticGroup 🔗 𝑨𝒍𝒔𝒐 𝒂𝒗𝒂𝒊𝒍𝒂𝒃𝒍𝒆 𝒐𝒏 Discord: https://discord.gg/CGvZ2Nu9 We look forward to having you attend the event!71Views0likes0CommentsPercentage of total (context and model)
Hi, I am creating a measure to calculate a "% of total" taking in the context the date field, but it only works if the date field is in the same table as the other values, i.e., when I try to use the date field from my DimCalendar it won't work. What am I doing wrong? Is it the modelling or the DAX? PBIX file avaliable in my OneDrive here. This works: % of year total = VAR amount = [Expenses] VAR TOT = CALCULATE( [Expenses], ALLEXCEPT(English, English[Year]) // English[Year] is a redundant calc col ) RETURN IF( SELECTEDVALUE(English[Year], "-") <> "-", DIVIDE (amount , TOT, "Error"), "Select a year" ) This doesn't: % of year total = VAR amount = [Expenses] VAR TOT = CALCULATE( [Expenses], ALLEXCEPT(DimCalendar, DimCalendar[Year]) // This won't work ) RETURN IF( SELECTEDVALUE(English[Year], "-") <> "-", DIVIDE (amount , TOT, "Error"), "Select a year" ) Thanks in advance for any tip.Solved869Views0likes2CommentsCrossfilter and row level security
Hello, I have the following model for a report: I've been asked to implement RLS and I'm having some trouble figuring out the correct method. In my original model table 1 does not exist and is not required. Table 1 is added for RLS amd contains a list of users email addresses, and the IDs which represent the rows I want the fact table, table 2, to filter to. One ID can be accessed my multiple users in table 1 which is why it is a many>many relationship. The RLS is setup to use Userprinciple name to filter table 1 and subsequently table 2. This element seems to work fine, as I can see when RLS is applied, table 2 does filter to the correct IDs the person in table 1 has access to. Due to table 2 being the fact table and on the many of the many>one side, it does not pass these filters through to the associated dimension tables. I have been reading into this as it is new to me, and thought I could use crossfilter within my measures to make the filters flow through to the dimension tables. As an example, for a measure that counts the rows in table 3 I thought I could try something like the below to count the total rows in table 3, but only for the rows which match those filtered in table 2: CountRowsTable3 = CALCULATE( COUNTROWS(Table3), CROSSFILTER('Table2'[ColumnA],Table3[ColumnA],Both) When I do this calc I still get the total number of rows in table 3 without the RLS applied. Grateful for any steers on the best way to do this, or if I am down totally the wrong track happy to be told so too! Thank you1.9KViews0likes3Comments