User Profile
AMPAllie
Helper II
Joined 7 years ago
User Widgets
Contributions
Measure with IFS or Filters
I need to calculate recruiting bonuses for two different people with two different criteria. The logic is as follows Billy: ((Billy's New Hires minus Terms) * 300) + ((Derek's New Hires minus Terms)*200) Derek: ((Derek's New Hires minus Terms) * 300) + ((Billy's New Hires minus Terms)*200) I've tried if statements, Calculating and filtering...but I can't seem to get the syntax right. In the "recruiter" column there will also be N/A besides the two names.Re: Extract Text with Wildcards
Here's a sample set. The circuit ID "CXXX" or "CXXXX" can be anywhere in the string. SDG&E PRiME C448-III SDG&E PRiME C448-Q SDG&E PRiME OPS 2021 C1076 C RECON SDG&E PRiME C448-T SDG&E PRiME C448-N SDG&E PRiME OPS 2021 C276 D Recon SDG&E PRiME C448-YY SDG&E PRiME OPS 2021 C276 E RECON SDG&E PRiME OPS 2021 C303 H RECON SDG&E PRiME OPS 2021 C1483 A RECONExtract Text with Wildcards
I have a column of project names. Somewhere in that string is the circuit ID. It begins with uppercase "C" and will have 3 OR 4 numbers behind it. Then a space, or a hyphen. The circuit ID is not in the same place in the string every time. And it may not be the only "C" or the only set of numbers in the string. Any ideas on how to extract it from the string?Running Total for Measure by Category
Hello All. This seems like it should be very simple, but I can't figure it out. I have a Matrix like so First three columns are in one table, Labor Spent in another and Delta is a measure: Delta = IF(MAX('PR PH TS Names and Budget'[PH#]) <> Blank(), SUM('PR PH TS Names and Budget'[Invoice Amount/Budget])-SUM('Labor Spent'[Labor Spent]), Blank()) What I need is a column for running total of Delta for each row that has a PH# and starts over at the next PR# Any help is much appreciated.
