Excel im betrieblichen Umfeld

  Country Rang =  RANKX( ALL(financials[Country]), [Umsatz],, DESC,Dense ) Country laufende Summe =  var _RangLand = RANKX( ALL(financials[Country]), [Umsatz],, DESC,Dense ) var _laufendeSumme = CALCULATE( [Umsatz], Filter(     ALL(financials[Country]),     _rangLand >= RANKX( ALL(financials[Country]), [Umsatz],, DESC,Dense ) ) ) RETURN _laufendeSumme

let     CheckInvisibleCharacters = (inputText as text) as logical =>     let         invisiblePatterns = {             "#(cr)",      // Carriage Return             "#(lf)",      // Line Feed             "#(cr)#(lf)", // Carriage Return + Line Feed             "#(tab)",     // Tab             Character.FromNumber(160),  // Non-breaking Space             Character.FromNumber(8203) // Zero-width Space         },         result = List.AnyTrue(List.Transform(invisiblePatterns, each Text.Contains(inputText, _)))     in         result in     CheckInvisibleCharacters