Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I am trying to create a calculated column that returns a yes or no based on the following conditions.
The max value in column A (LP Actuals'[Last Quantity Entered in past 15 days]) is 1 and also max value in column B ([Last Hours Entered in past 15 days]) is also 1 for that particular job id.
The dataset is a little complicated in the sense that on any particular row, we will not have value for column a and b at the same time. So essentially we need to go through all rows for that particular job and if there is a max value of 1 in column A and max value of 1 in column B, then it must return yes else no
IF(MAX('LP Actuals','LP Actuals'[Last Quantity Entered in past 15 days]=1 && MAX('LP Actuals','LP Actuals'[Last Hours Entered in past 15 days]=1) && 'LP Actuals'[Job Code]=EARLIER('LP Actuals'[Job Code]),"yes","no"))))
Solved! Go to Solution.
I think this might be closer (and maybe easier to read)
New Ccolumn = VAR Col1 = CALCULATE(MAX('LP Actuals'[Last Quantity Entered in past 15 days]),'LP Actuals'[Job Code] = EARLIER('LP Actuals'[Job Code])) VAR Col2 = CALCULATE(MAX('LP Actuals'[Last Hours Entered in past 15 days]),'LP Actuals'[Job Code] = EARLIER('LP Actuals'[Job Code])) RETURN IF( Col1=1 && Col2=1 , --THEN-- "Yes", --ELSE-- "No" )
I think this might be closer (and maybe easier to read)
New Ccolumn = VAR Col1 = CALCULATE(MAX('LP Actuals'[Last Quantity Entered in past 15 days]),'LP Actuals'[Job Code] = EARLIER('LP Actuals'[Job Code])) VAR Col2 = CALCULATE(MAX('LP Actuals'[Last Hours Entered in past 15 days]),'LP Actuals'[Job Code] = EARLIER('LP Actuals'[Job Code])) RETURN IF( Col1=1 && Col2=1 , --THEN-- "Yes", --ELSE-- "No" )
Thanks Phil
Works well
Phil
Thanks for your help. I am experiencing an unusal situation. If I add any calculated column, after the one you helped me to create it says A circular dependency was detected
Can you make a guess on what might be happening
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |