new column
9 Topics
Populate a new column with data from conditional row
Hi, I am new to Power BI report building and I'm hoping you can help - I'm sure there is a simple solution but I don't know what it is! I have a table like the one below and want to create an additional column called "ORIGINAL SOURCE" that shows the value in the SOURCE column for EVENT NO 1 in every row for the relevant REF VALUE. REF EVENT_NO SOURCE 001 1 A 001 2 A 001 3 B 001 4 B 001 5 D 002 1 C 002 2 D 002 3 A 002 4 B 002 5 C 002 6 D So it will look like this: REF EVENT_NO SOURCE ORIGINAL SOURCE 001 1 A A 001 2 A A 001 3 B A 001 4 B A 001 5 D A 002 1 C C 002 2 D C 002 3 A C 002 4 B C 002 5 C C 002 6 D C I would appreciate anyone's advice on the best way to achieve this. Many Thanks,Solved425Views0likes1Comment
Greater than or less than dates = April 2023 etc
I want to add a new column to a table with the months defined from the dates column can't seem to get this working. Any help greatly appreciated. Dates = IF ( [Date_Column] >= (2023, 04, 01) && [Date_column] <= (2023, 04, 30) then "April 2023" else "") Liekwise what would i have to do to do this for other months eg Dates = IF ( [Date_Column] >= (2023, 04, 01) && [Date_column] <= (2023, 04, 30) then "April 2023" else "", IF ( [Date_Column] >= (2023, 05, 01) && [Date_column] <= (2023, 05, 31) then "May 2023" else "",Solved1.1KViews0likes3Comments
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. PowerBISample1.4KViews0likes4Comments
Calculated Column filter dynamic
Hi I have created a new column with dax this way : MCS = VAR CurrentKey = 'Release planner'[FC ID] VAR MultifactorFiltered = FILTER('Multifactor PI Calculator', 'Multifactor PI Calculator'[Multifactor PI] = "2023PI3") VAR MatchingKey = COUNTROWS(FILTER(MultifactorFiltered, 'Multifactor PI Calculator'[FC number] = CurrentKey)) VAR DividerToUse = IF( MatchingKey > 0, MAXX(MultifactorFiltered, [Value]), 'Release planner'[FC size] ) RETURN IF( DividerToUse < 1, 'Release planner'[MCS Effort] * DividerToUse, 'Release planner'[MCS Effort] / DividerToUse ) There reason behind this is that sometimes the column need to be calculated from a different table. I am using this column on different tabs as well and it needs to be able to change by everytab. In the line 3 "2023PI3" part needs to be dynamic in someways, slicer filter not sure. I have tried to create a new table with just these values and use it as a slicer but it would change the end value. Thanks inadvanceSolved899Views0likes4CommentsCalculated Column Based on two tables
I have two tables: Table 1 Name Email John Doe [email protected] John Doe [email protected] Larry Fitz [email protected] John Elway [email protected] John Elway [email protected] John Elway [email protected] Table 2 Name Email Date Submitted John Elway [email protected] 1/1/2023 Joe Burrow [email protected] 5/1/2022 Larry Fitz [email protected] 12/1/2022 Brian Urlacher [email protected] 9/1/2022 I want to create a new column using DAX on Table 1 called "Eligibility" where: IF the inidivudla has a submission on Table 2 from the past 3 months, it says "Yes", other wise "No". Intended Result would be: Name Email Eligibility John Doe [email protected] No John Doe [email protected] No Larry Fitz [email protected] Yes John Elway [email protected] Yes John Elway [email protected] Yes John Elway [email protected] Yes Thank you in advance!Solved807Views0likes2Comments
Use SELECTEDVALE() in logic for new dax column
Hi All, I have an report in PBI that allows the end user to input their own targets (SLA's) by adding a numeric parameter for each of the 4 SLA's SLA 2 Target = GENERATESERIES(0, 50, 1) SLA 2 Target Value = SELECTEDVALUE('SLA 2 Target'[SLA 2 Target]) It works well proving I use [SLA 2 Target Value] on the same page as the slicer containing the series. Outside this page the measure does not work as expected I have managed to pass the value to other report pages by syncing hidden slicers, but what I really need to do is use the value in an IF statement for a new dax column. For example if the user entered the value '10' into the slicer: This works New Column Outcome = IF( Table[SLA 2 Days] > 10, "Out of SLA", "Completed In Time") This does not work New Column Outcome = IF( Table[SLA 2 Days] > [SLA 2 Target Value], "Out of SLA", "Completed In Time") Any help appreciated All the best VickySolved443Views0likes1CommentDifference between two values when one of the value is blank
Hi All, I am a newbie to PBI. I have run into this issue with my matrix visual Delta is calculated basically as the difference between Date 1 & Date 2 using DAX. If there is value in Date 1 (say 100) and a value in Date 2 (70) the Delta is 30. But like the table below sometimes the value in Date 1 is blank/empty/null and Date 2 has a value and vice verse . If that is the situation I need the Delta to show up as a negative and positive value respectively. For example (see first 2 rows...3rd and 4th row are working as expected) Date 1 Date 2 Delta 100 -100 100 100 90 60 30 60 90 -30 Can someone help with this? Thanks!Solved632Views0likes1CommentNew column with value of next row grouped/filtered by multiple columns
Hi everyone, since I'm no DAX pro, I urgently need your help with the following issue. Background: I'm analyzing the use of electronic devices. To be specific, I want to know how often users start different sequential programs in the daily use. That is, if a certain program on device A on day x is started, what is the next program? Data basically looks like this: Device ID Timestamp Program ID A 2022-01-01 14:38 ID1 B 2022-01-01 09:12 ID 2 A 2022-01-03 19:45 ID 3 C 2022-01-04 19:45 ID 2 B 2022-01-01 11:03 ID 2 B 2022-01-01 22:54 ID 1 A 2022-01-03 23:09 ID 1 I need a new column "NextProgramSameDay" which, for every distinct device and every single day, contains the program ID of the directly following program on the same day: Device ID Timestamp Program NextProgramSameDay Comment (for clarification, not to be included in the dataframe) A 2022-01-01 14:38 ID 1 no next program because no additional program was started on the same day in device A B 2022-01-01 09:12 ID 2 ID 2 Next program on device B on same day is program 2 at 11:03 A 2022-01-03 19:45 ID 3 ID 1 Next program on device A on same day is program 1 at 23:09 C 2022-01-04 19:45 ID 2 no next program because no additional program was started on the same day in device C B 2022-01-01 11:03 ID 2 ID 1 Next program on same day in device B is program 1 at 22:54 B 2022-01-01 22:54 ID 1 no next program because no additional program was started on the same day in device B A 2022-01-03 23:09 ID 1 no next program because no additional program was started on the same day in device A Can anyone tell me how to accomplish this? Thanks a lot in advance!!!Solved1.2KViews0likes6CommentsCreate 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 columnSolved4.9KViews0likes5Comments
