https://community.fabric.microsoft.com/t5/Developer/tabular-editor-Loop-through-Calculated-Columns/m-p/4017397#M53799 <P>The documentation seems to indicate that the type exists.</P> <P><A href="https://docs.tabulareditor.com/api/TabularEditor.TOMWrapper.ColumnType.html" target="_blank">Enum ColumnType | Tabular Editor Documentation</A></P> <P>&nbsp;</P> <P>What does "doesn't work"&nbsp; mean?</P> Mon, 01 Jul 2024 00:56:07 GMT lbendlin 2024-07-01T00:56:07Z https://community.fabric.microsoft.com/t5/Developer/tabular-editor-Loop-through-Calculated-Columns/m-p/4015776#M53782 <P>Hi</P><P>im writing a C# script in Tabular Editor to loop through the model and change the naming convention of measures and calculated columns (inherited several reports from business and its a bit messy) the Measure part works perfectly - code adds "Msr" abbreviation to each measure and moves it to Calculations. The problem appears with calculated columns - seems like the check of columnType.Calculated doesnt work. Does anyone know how to check the columntype properly?</P><P>Thank you:)</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="csharp">var calcTable = Model.Tables.FirstOrDefault(t =&gt; t.Name == "Calculations"); Func&lt;string, string, string&gt; FormatName = (name, prefix) =&gt; { string formattedName = name.Replace(" ", "_"); if (!formattedName.StartsWith(prefix)) { formattedName = prefix + formattedName; } return formattedName; }; foreach (var table in Model.Tables) { foreach (var measure in table.Measures.ToList()) { measure.Name = FormatName(measure.Name, "Msr"); measure.MoveTo(calcTable); } foreach (var column in table.Columns.ToList()) { if (column.ColumnType== ColumnType.Calculated) { if (!column.Name.StartsWith("CC")) { column.Name = FormatName(column.Name, "CC"); } } } }</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 28 Jun 2024 14:00:45 GMT https://community.fabric.microsoft.com/t5/Developer/tabular-editor-Loop-through-Calculated-Columns/m-p/4015776#M53782 MattReckoner111 2024-06-28T14:00:45Z https://community.fabric.microsoft.com/t5/Developer/tabular-editor-Loop-through-Calculated-Columns/m-p/4017397#M53799 <P>The documentation seems to indicate that the type exists.</P> <P><A href="https://docs.tabulareditor.com/api/TabularEditor.TOMWrapper.ColumnType.html" target="_blank">Enum ColumnType | Tabular Editor Documentation</A></P> <P>&nbsp;</P> <P>What does "doesn't work"&nbsp; mean?</P> Mon, 01 Jul 2024 00:56:07 GMT https://community.fabric.microsoft.com/t5/Developer/tabular-editor-Loop-through-Calculated-Columns/m-p/4017397#M53799 lbendlin 2024-07-01T00:56:07Z