Dashboard in a day using Power BI
Event Title: Dashboard in a day using Power BI Event Description: Join us for an engaging and informative webinar where you'll gain valuable insights into Microsoft Power BI Desktop. This session is designed to provide a comprehensive understanding of creating Business Intelligence Reports using this powerful tool. Agenda: a) Introduction to Microsoft Power BI Desktop: Explore the fundamental aspects of Power BI Desktop, understand its interface, and get familiar with its functionalities. b) Creating a Business Intelligence Report: Walk through a complete step-by-step process on how to craft effective and insightful Business Intelligence Reports using Power BI Desktop. c) Interactive Q&A Session: Engage in an interactive session where you can ask questions, seek clarification, and interact with our experts. Language: The webinar will be conducted in Bangla (বাংলা) to ensure clear communication and understanding. Target Audience: This session is tailored for individuals who are new to Power BI and students keen on delving into Business Intelligence. However, it's an open invitation to anyone interested in enhancing their understanding of this topic. Additional Information: Platform: Microsoft Teams - To make the most of the session, we highly recommend downloading the Microsoft Teams app. Some features may not be fully supported on certain browsers. Participant Information: Please note that upon joining the event, your name, email, or phone number may be visible to other attendees in the participant list. Your consent to this experience is assumed upon joining the webinar. Don't miss out on this opportunity to expand your knowledge and proficiency in Microsoft Power BI Desktop! We look forward to having you join us for this insightful session.Data Analytic Group - Global Fabric Data Days – DP-600
Join us for Global Fabric Data Days – DP-600: Fabric Analytics Engineer Associate, a focused session hosted by the @data Analytic Group (DAG) community. This 4.5-hour session is designed for data professionals looking to strengthen their skills in Microsoft Fabric and prepare for the DP-600: Implementing Analytics Solutions Using Microsoft Fabric certification. We'll cover key exam domains Speakers: 1. Girish Govilkar -DP-600 Study Group – Session 1 - Get started with Lakehouses 2. M V Aditya Kumar Akella -DP-600 Study Group – Session 2 - Get started with Data Warehouses 3. Wael BAAZOUZI -DP-600 Study Group – Session 3 - Add measures to semantic models 4. INTURI SUPARNA BABU - DP-600 Study Group – Session 4 - Real-time intelligence 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!
Table Visualization doesn't work when Measure is added
I'm creating a visual that shows the Operator Name, his/her Operator Code, and the associated amount of scrap ($) associated with their work. I can get the Operator Name and Operator Code to match up, but when I add the measure, the measure shows the Total value all the way down. I recognize this as a relationship problem, but I have the Operator Code in both of the tables from which I'm pulling the data so I figured that would solve the relationship problem. The only other thing I can think of is that the measure somehow is messing up the relationship. ProdData Item_No Operator Vertical Top Bottom Model Vertical Min Length Vertical Max Length F/B Min Length F/B Max Length T/B Min Length T/B Max Length Vertical IT/OT Top IT/OT Bottom IT/OT Complete I-beam Count Incomplete I-beam Count 1 Op-1 199.9982 99.9979 60.0011 HP500 199.99 200.02 99.99 100.07 59.998 60.003 IT IT IT 1 0 21 Op-1 200.0143 99.9879 59.9993 HP500 199.99 200.02 99.99 100.07 59.998 60.003 IT OT IT 0 1 22 Op-1 200.0034 100.0046 60.0027 HP500 199.99 200.02 99.99 100.07 59.998 60.003 IT IT IT 1 0 23 Op-1 200.0161 100.0034 59.9988 HP500 199.99 200.02 99.99 100.07 59.998 60.003 IT IT IT 1 0 24 Op-1 199.9845 99.9937 59.9988 HP500 199.99 200.02 99.99 100.07 59.998 60.003 OT IT IT 0 1 Part Costs Model Vertical Cost Top Cost Bottom Cost I-Beam Cost HP500 $ 4.95 $ 2.87 $ 6.01 $ 13.83 Operators Operator Code Operator Name Model Op-1 Anderson HP500 Op-2 Betts HP500 Op-3 Carhart HP500 Op-4 Dennison HP500 Op-5 Evers HP500 Op-6 Franks HP500 Op-7 Guilfoyle HP500 Op-8 Harris HP500 Op-9 Ingalls HP500 Op-10 Janison HP500 Op-11 Kelty HP500 Op-12 Lassiter HP500 Op-13 Michaels HP500 Op-14 Norris HP500 Op-15 Oates HP500 Op-16 Payton HP500 Op-17 Quincy HP500 Op-18 Rawlings HP500 Op-19 Stevens HP500 Op-20 Thomas HP500 Measure I-Beam Scrap Cost = SUMX ( VALUES ( ProdData[Model] ), VAR OperatorIncompleteCount = CALCULATE ( SUM ( 'ProdData'[Incomplete I-beam Count] ), 'ProdData'[Incomplete I-beam Count] = 1, 'ProdData'[Model] = EARLIER ( ProdData[Model] ) ) RETURN OperatorIncompleteCount * SUMX ( RELATEDTABLE('Part Costs'), 'Part Costs'[I-Beam Cost] ) )Create a Flag measure based on Start date and End Date.
Hello All, I have a table and I need to show records between start date and End date. Need to create a flag which has to be 1 for dates which is between start date and End Date. So that I can drop flag in measure and select "1" to show the records. Below is the Dax I used but gettting error "Multiple Values supplied instead of one" Flag = Var startdate=SELECTEDVALUE('Selection Values'[CAL_DT]) var Startdate_plus = startdate+1 Var PStrt_date= startdate-365 var enddate= startdate+14 return IF(AND(VALUES(V_DAILY_SERVICE_CALL_LOG[CAL_DT]) >= IF(VALUES(V_DAILY_SERVICE_CALL_LOG[STATUS_ID]) IN {"A501","A405","A411"},PStrt_date,Startdate_plus),VALUES(V_DAILY_SERVICE_CALL_LOG[CAL_DT]) <= enddate),1,0 Here (V_DAILY_SERVICE_CALL_LOG[CAL_DT] is retireved by using lookup from date table. Below is the model: My fact table is V_DAILY_SERVICE_CALL_LOG. Date slicer is coming from a separate table which is not in relation with Fact table and Service dest is coming from a Dimension table which is in One to Many relation with Fact. Relative SQL query for flag is below, I want to convert that Flag query to Flag measure so that I can drop this to Table Vizualization filter pane:- Select * from( Select f.*, CASE When d.CAL_DT BETWEEN (CASE WHEN STATUS_ID IN ('A501','A405','A411') THEN DATEADD(DAY,-365,'2023-03-04') ELSE DATEADD(DAY,1,'2023-03-04') END) AND DATEADD(DAY,14,'2023-03-04') THEN 1 ELSE 0 END as Flag from "LESL_DW_UAT"."PBI_MART"."V_DAILY_SERVICE_CALL_LOG" f inner join "LESL_DW_UAT"."PBI_MART"."V_DATE_DIM" d on f.DT_SKEY = d.DT_SKEY inner join "LESL_DW_UAT"."PBI_MART"."V_STORE_SERVICE_DIM" s on f.STORE_KEY = s.STORE_KEY where s.SERVICE_DSTRCT_CD ='22' ) A where Flag = 1Area selection in Model view
Are there any plans to add the feature that allows us to select areas in the model view in Power BI Desktop. Right now the only way to select multiple tables to move them around, is to CTRL + Select each one of them, which isn't as efficient as selecting a whole area with our mouse.
Pulling field in another table connected via an inactive relationship
Hello I have the three table below: that are related as follows: (1)-> *: Active Directory User[User], Workspace_All_RAW[user] (1)-> *: Active Directory User[User], Datasets[ConfigureBy], Inactive (1)-> *: Dataset[DatasetID], Workspace_All_Raw[DatasetID] In my report, i am creating a slicer based on Active Directory User[User]. I am trying to pull the Name of workspace from Workspace_All_Raw table (working good) and the Dataset Name from the DataSets table using a measure: Measure = CALCULATE(SELECTEDVALUE(DataSets[Name]),USERELATIONSHIP(DataSets[ConfiguredBy],'Active Directory Users'[Users])) but my measure is showing nothing when placed in a table visual. 1- How can i get the datasets name? 2- Is it possible to redesign my model in a different way to avoid having this inactive relationship?
How to handle this requirement?
Hi all, I've been struggling with a scenario for a while which I want to solve properly. Below I've created a model which contains the relevant tables from a more complex data model. The requirement Calculate the following Divide this SUM(Fact_Marketvalue.Marketvalue) * SUM(Fact_Rating.Carbonemission) where the Fact_Ratings.Carbonemission > 5) by this SUM(Fact_Marketvalue.Marketvalue) > 5 ) The result should by sliceable by Category, Customer, Security and more Dimension tables in my model. Right now I created many-many relationships between Fact_MarketValue and Fact_Ratings on the Security ID, but I want to avoid this relationship. What would be the best thing to do? Create a view in SQL which holds all information needed, if so, I want to keep it as lean as possible? or should I create a bridge table, if so, with what information? Or maybe I am missing some DAX magic..
