How to list out my output results
Lookup keyword using "Searchsheet" table to find match in "Stringsheet" table. 2 types of conditions: (i) When BOTH [Search1] AND [Search2] are found in "Stringsheet" table; (ii) When Either [Search1] OR [Search2] are found in "Stringsheet" table; List out the results found. Appreciate your help greatly to list out the results found in yellow highlights below. I am not familiar with List function. Thank you. Link for my Power Bi file : List out results ContainsString AND = VAR __String = [String1] VAR __Table = ADDCOLUMNS( 'Searchsheet', "Found", CONTAINSSTRING( __String, [Search1]) && CONTAINSSTRING( __String, [Search2])) VAR __Result = IF( COUNTROWS( FILTER( __Table, [Found] = TRUE() ) ) > 0, TRUE(), FALSE() ) RETURN __Result ContainsString OR = VAR __String = [String1] VAR __Table = ADDCOLUMNS( 'Searchsheet', "Found", CONTAINSSTRING( __String, [Search1])) VAR __Table1 = ADDCOLUMNS( 'Searchsheet', "Found", CONTAINSSTRING( __String, [Search2])) VAR __Result = IF( COUNTROWS( FILTER( __Table, [Found] = TRUE() ) ) > 0, TRUE(), IF( COUNTROWS( FILTER( __Table1, [Found] = TRUE() ) ) > 0, TRUE(), FALSE() ) ) RETURN __Result
Backing out from quarterly to monthly
Help me Rhonda! <---Also, not sure if Dax is the right place for this post, so please let me know if I should repost elsewhere. Our organization collects performance measure data from internal program areas via Microsoft Power Apps. That info is stored in about a dozen SharePoint Lists. Data is entered in monthly (sometimes more often but that is because people make mistakes and have to re-enter the data). This shows in the lists pmd_element data. The App was originally designed to report on a quarterly basis, so that info gets rolled up to that time period for what was approved by the manager and shows in the pmd_measure data List. You'll see that the Numerator/Denominator columns are actually references to rows in the pmd_element data List, so they are referencing the entries that were ultimately approved and are legit. How can I back out of this to show the monthly approved entries though? I've been able to do stuff on this quarterly basis, but now leadership wants it monthly and I'm losing my mind. The person who created the App left and I have hardly any experience in that realm. On top of that, I also need to account for the fact there are different types of measures (e.g. percentage of calls taken vs a sum of number of complaints received) and that some measures are cumulative (aggregating for the year) and others non-cumulative (only needing to show for that quarter or other time period). There are other lists like pmd_target and pmd_measure that have columns to help with that aspect, but I'm lost on how to handle those as well. Anyway, what do you think? What can I do? What extra info can I give you to help you help me 🙂
