User Profile
efstel
Helper I
Joined 3 years ago
User Widgets
Contributions
Conditional Column with Multiple Conditions
I am adding a conditional column in power query editor and pulling numbers out of a column named Amount. When the value in the Column named GLAcct does not end with ". " or does not contain ".CORP". And I'm creating another column similarly when the value in the Column named GLAcct ends with ". " or contains ".CORP". (See screen shots below.) The problem is that the first conditional column includes values in the Amount column when ".CORP" is contained within the column.Re: Subtotal and totals not computing correctly
That is not working correclty. Also, I can't create a relationship between the 'JCCD' table and the 'bihj HeavyJob_CostSummary' table other than a many to many. The tables come from two different data sources and have millions of lines of data. However, there is the following relationship between the tables. JCJP is a dimension table and contains unique JobNoCostCode. 'JCCD' and 'bihj HeavyJob_CostSummary' are both fact tables.Subtotal and totals not computing correctly
I have two tables and want to use the values in the table/column 'JCCD'[ActualCost] except when in the values in table/column 'bihj HeavyJob_CostSummary'[HJCost] are higher than in the 'JCCD'[ActualCost] table/column only when 'HeavyJob_CostSummary'[LMSEO] or 'JCCD'[LMSEO] has a value of "Labor" or "Material". This works with the following: NewColumn = IF( [HJCost minus ActualCost] > 0, SUM('bihj HeavyJob_CostSummary'[HJCost]), SUM('JCCD'[ActualCost]) ) or: NewMeasureCO = VAR LMSEO_Value = SELECTEDVALUE('bihj HeavyJob_CostSummary'[LMSEO]) VAR HJCost = SUM('bihj HeavyJob_CostSummary'[HJCost]) VAR ActualCost = SUM('JCCD'[ActualCost]) RETURN IF( LMSEO_Value IN {"Labor", "Material"} && HJCost > ActualCost, HJCost, ActualCost ) However, when you subtotal or total all the values they are not correct. How do I get the subtotal and total to compute the correct value?Totals from measured column are not adding up in Table. Individual rows are correct.
Totals from measured column are not adding up. Individual rows are correct. Here's the measure for the revenue column: Revenue = MIN([ContractOverrideWIP], IF([Contract Override minus ECAC Override] < 0, [Contract Override minus ECAC Override] + [ActualCost], [ContractOverrideWIP] * [WIP%Complete])) and the underlying measures: ContractOverrideWIP = SUM(WIP[Contract Override]) Contract Override minus ECAC Override = SUM('WIP'[Contract Override]) - SUM('WIP'[ECAC Override]) ActualCost = SUM(JCCD[ActualCost]) WIP%Complete = DIVIDE(SUM('JCCD'[ActualCost]), SUM('WIP'[ECAC Override])) Any suggestions on what is going on?
