Madison Power BI Apr 2022 - Junk Dimensions
In dimensional modeling, dimensions are often a tangible thing: the date, the time, the customer, the employee, the location, the product. It's something you can see and point to; even have a conversation with. But what happens when your dimension isn't a tangible thing? When it's just a collection of random pieces of information? How do you model things that aren't things? This is where you enter the murky world of junk and degenerate dimensions. Let's talk about why junk might be exactly what your model needs. PLUS, if you have your own Power BI/star schema modeling questions or challenges, bring them to share with the group and let's see if we can't help. --- The meeting will start at 6pm and end at 7.30pm on Wednesday April 6th. We'll have pizza and soft drinks. We do ask that you wear a mask. ***NEW LOCATION*** We'll be meeting on the ground floor of the Hy Cite offices in Middleton: 3252 Pleasant View Rd, Middleton, WI 53562. It's on the far west side - exit the beltline on Airport Rd (exit 250). Hy Cite is on the corner of N Pleasant View Rd and Airport Rd just before Airport Rd goes from 2 lanes to 1. The main entrance is on the Airport Rd side of the building. What3Words: ///trees.laser.boat --- Unrelated, if you are looking for (or are open to) a new position that uses your Power BI skills, get in touch! We’re aware of at least 2 companies hiring in the Power BI space right now.
Replicate Pivot into PowerBI and using DAX
Please assist: I have brought in the Pivot table as an example of what the PowerBI report should look like, see:https://drive.google.com/file/d/1_XyrEdRUsQImyuDhapkA5fqcpXRGUjRV/view?usp=sharing . My Fact Data, https://docs.google.com/spreadsheets/d/1mN6dGl4NY9N8yrXDpmx_CTJnZbxL61Zi/edit?usp=sharing&ouid=10412... Cash Flow tab in this file, https://docs.google.com/spreadsheets/d/1mN6dGl4NY9N8yrXDpmx_CTJnZbxL61Zi/edit?usp=sharing&ouid=10412... represents the final look with calculations as seen in my PBIX file. Source Data in the same file is my data in SQL DB. Please advise what will be the best way to get my data model/report aligned so that I can do the formulas in PowerBI using DAX as seen in the Cash Flow tab, column K.
DAX Function to Concatenate Distinct Values from a Dimension Grouped by a Different Dimension Column
Hello, Looking for the Community's help on this. I have the below data model. I want to create a column with DAX to concatenate product categories form DimProduct by the Employee to show all the categories that this employee sold. What I got from CONCATENATEX is repeated values and blank values of categories an Employee did not sell. Appreciate your help on this. Desired Outcome: Employee First Name Employee Last Name Categories Sold John Doe A, B, C, D Jane Doe B, C Lord Voldemort D Severus Snape A, C EDIT (26-10-2023): I am trying to create this a DAX column in the DimProduct table.
Mulitply columns from 2 fact tables (not directly related, but through 2 dimension tables)
Dear PowerBi Community, i am kinda frustrated here and hope someone can help me with dax. I have a data model that holds two fact tables fct_contract_employee and fct_time_tracking. The tables are related through the dim tables as you can see in the data model. I just cant figure out a dax formula to multiply those two. This doesnt work because there is no direct relation between the two tables: Measure = SUMX(Contracts, Table1[Column1] * RELATED(Table2[Column2])) Filtering based on the dim columns doesnt work either: SUMX (FCT_TIME_TRACKING_CONTRACT_LEGACY, FCT_TIME_TRACKING_CONTRACT_LEGACY[TRACKED_WORKING_DAYS] * CALCULATE( FCT_CONTRACT_EMPLOYEE[DAILY_RATE], FILTER( FCT_CONTRACT_EMPLOYEE, FCT_CONTRACT_EMPLOYEE[EMPLOYEE_ID] = RELATED( FCT_TIME_TRACKING_CONTRACT_LEGACY[employee_id]) && FCT_CONTRACT_EMPLOYEE[contract_id] = RELATED( FCT_TIME_TRACKING_CONTRACT_LEGACY[contract_id] ) ) ) )
