pulling new columns from SharePoint List
I have an existing Power BI tool that is pulling data from a SharePoint List on a daily basis. My team added two new columns to the List, and I need those two new columns to also pull into the Power BI tool. How would I do that? I thought they would come in automatically and I don't see where to add them in table view.
Combine Rows in a Matrix Table
Help I want to combine quantity rows into one row. For Example (What I know): If selected BatchNo is Batch-202 & Batch-203. I will take the (Max) ActualValue for each BatchNo then Sum it and replace the old value with the new calculated value. Then my Matrix table will combine these numbers. I already have a table that have a maximum value for each BatchNo (if it is useful). Condition: Only for Quantity or when Order = 2. pbx file and sample data attached. PowerBISample
Create new column using Dax to pull data from 2 table to make the new column
Hi I have 2 tables. in which I need to create a new Column where its pulling data from both tables. Table 1 is the main table that has the key information that is related to Table 2 Primary Item Nmber. Table 1 has some part numbers that are longer in nature the Dax formula needs to look at table 2 Engineering item number to find the same part number to makethe new column Table 1 Table 2 Table 1 with new column
