topic Format Month in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Format-Month/m-p/3374650#M7865 <P>Hello,</P><P>Simple thing, but I don't know how to reach it. Just want to have "September" for Month 1 as it's my first Fiscal Month, "October" for Fiscal Month 2, etc... instead of 1,2,3,4,...</P><P>&nbsp;</P><P>Where to put in in this programmation?</P><P>&nbsp;</P><DIV><DIV><SPAN>Dates = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>FirstCY</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>( </SPAN><SPAN>FIRSTDATE</SPAN><SPAN>(</SPAN><SPAN>'Feuil1 (2)'</SPAN><SPAN>[date_de_la_facture]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>FirstCM</SPAN><SPAN> = </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>FIRSTDATE</SPAN><SPAN>(</SPAN><SPAN>'Feuil1 (2)'</SPAN><SPAN>[date_de_la_facture]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>FirstFY</SPAN><SPAN> = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>FirstCM</SPAN><SPAN> &lt;=</SPAN><SPAN>8</SPAN><SPAN>, </SPAN><SPAN>FirstCY</SPAN><SPAN> - </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>FirstCY</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>LastCY</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>( </SPAN><SPAN>LASTDATE</SPAN><SPAN>(</SPAN><SPAN>'Feuil1 (2)'</SPAN><SPAN>[date_de_la_facture]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>LastCM</SPAN><SPAN> = </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>LASTDATE</SPAN><SPAN>(</SPAN><SPAN>'Feuil1 (2)'</SPAN><SPAN>[date_de_la_facture]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>LastFY</SPAN><SPAN> = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>LastCM</SPAN><SPAN> &lt;=</SPAN><SPAN>8</SPAN><SPAN>, </SPAN><SPAN>LastCY</SPAN><SPAN>, </SPAN><SPAN>LastCY</SPAN><SPAN> + </SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>DatesTable</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>CALENDAR</SPAN><SPAN>(</SPAN><SPAN>"01/09/"</SPAN><SPAN>&amp;</SPAN><SPAN>FirstFY</SPAN><SPAN>, </SPAN><SPAN>"31/08/"</SPAN><SPAN>&amp;</SPAN><SPAN>LastFY</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN><SPAN>DatesTable</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>"Year"</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"FiscalYear"</SPAN><SPAN>, </SPAN><SPAN>"FY"</SPAN><SPAN> &amp;</SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;=</SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>"CalendarMonth"</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"FiscalMonth"</SPAN><SPAN>, </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) - </SPAN><SPAN>8</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>4</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"CalendarQuarter"</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><BR /><DIV><SPAN>"FiscalQuarter"</SPAN><SPAN>, </SPAN><SPAN>"Q"</SPAN><SPAN>&amp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>7</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) - </SPAN><SPAN>2</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>1</SPAN><SPAN>),</SPAN></DIV><BR /><DIV><SPAN>"FY&amp;YQuarter"</SPAN><SPAN>, </SPAN><SPAN>"FY"</SPAN><SPAN> &amp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>)) &amp; &nbsp;</SPAN><SPAN>" - Q"</SPAN><SPAN> &amp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) - </SPAN><SPAN>2</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>2</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"Month&amp;Year"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>, </SPAN><SPAN>"mmm yyyy"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"MonthOrderID"</SPAN><SPAN>, </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;=</SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>)) * </SPAN><SPAN>100</SPAN><SPAN> + </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) - </SPAN><SPAN>8</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>4</SPAN><SPAN>), </SPAN></DIV><DIV><SPAN>"WeekDay"</SPAN><SPAN>, </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>WEEKDAY</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>, </SPAN><SPAN>2</SPAN><SPAN>) &lt; </SPAN><SPAN>6</SPAN><SPAN>, </SPAN><SPAN>"WeekDay"</SPAN><SPAN>, </SPAN><SPAN>"Weekend"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"Day"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>, </SPAN><SPAN>"dddd"</SPAN><SPAN>))</SPAN></DIV></DIV> Thu, 10 Aug 2023 16:17:26 GMT sportive92003 2023-08-10T16:17:26Z Format Month https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Format-Month/m-p/3374650#M7865 <P>Hello,</P><P>Simple thing, but I don't know how to reach it. Just want to have "September" for Month 1 as it's my first Fiscal Month, "October" for Fiscal Month 2, etc... instead of 1,2,3,4,...</P><P>&nbsp;</P><P>Where to put in in this programmation?</P><P>&nbsp;</P><DIV><DIV><SPAN>Dates = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>FirstCY</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>( </SPAN><SPAN>FIRSTDATE</SPAN><SPAN>(</SPAN><SPAN>'Feuil1 (2)'</SPAN><SPAN>[date_de_la_facture]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>FirstCM</SPAN><SPAN> = </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>FIRSTDATE</SPAN><SPAN>(</SPAN><SPAN>'Feuil1 (2)'</SPAN><SPAN>[date_de_la_facture]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>FirstFY</SPAN><SPAN> = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>FirstCM</SPAN><SPAN> &lt;=</SPAN><SPAN>8</SPAN><SPAN>, </SPAN><SPAN>FirstCY</SPAN><SPAN> - </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>FirstCY</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>LastCY</SPAN><SPAN> = </SPAN><SPAN>YEAR</SPAN><SPAN>( </SPAN><SPAN>LASTDATE</SPAN><SPAN>(</SPAN><SPAN>'Feuil1 (2)'</SPAN><SPAN>[date_de_la_facture]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>LastCM</SPAN><SPAN> = </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>LASTDATE</SPAN><SPAN>(</SPAN><SPAN>'Feuil1 (2)'</SPAN><SPAN>[date_de_la_facture]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>LastFY</SPAN><SPAN> = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>LastCM</SPAN><SPAN> &lt;=</SPAN><SPAN>8</SPAN><SPAN>, </SPAN><SPAN>LastCY</SPAN><SPAN>, </SPAN><SPAN>LastCY</SPAN><SPAN> + </SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>DatesTable</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>CALENDAR</SPAN><SPAN>(</SPAN><SPAN>"01/09/"</SPAN><SPAN>&amp;</SPAN><SPAN>FirstFY</SPAN><SPAN>, </SPAN><SPAN>"31/08/"</SPAN><SPAN>&amp;</SPAN><SPAN>LastFY</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN><SPAN>DatesTable</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>"Year"</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"FiscalYear"</SPAN><SPAN>, </SPAN><SPAN>"FY"</SPAN><SPAN> &amp;</SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;=</SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>"CalendarMonth"</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"FiscalMonth"</SPAN><SPAN>, </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) - </SPAN><SPAN>8</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>4</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"CalendarQuarter"</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN></DIV><BR /><DIV><SPAN>"FiscalQuarter"</SPAN><SPAN>, </SPAN><SPAN>"Q"</SPAN><SPAN>&amp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>7</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) - </SPAN><SPAN>2</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>1</SPAN><SPAN>),</SPAN></DIV><BR /><DIV><SPAN>"FY&amp;YQuarter"</SPAN><SPAN>, </SPAN><SPAN>"FY"</SPAN><SPAN> &amp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>)) &amp; &nbsp;</SPAN><SPAN>" - Q"</SPAN><SPAN> &amp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) - </SPAN><SPAN>2</SPAN><SPAN>, </SPAN><SPAN>QUARTER</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>2</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"Month&amp;Year"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>, </SPAN><SPAN>"mmm yyyy"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"MonthOrderID"</SPAN><SPAN>, </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;=</SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>)) * </SPAN><SPAN>100</SPAN><SPAN> + </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) &gt;= </SPAN><SPAN>9</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) - </SPAN><SPAN>8</SPAN><SPAN>, </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>) + </SPAN><SPAN>4</SPAN><SPAN>), </SPAN></DIV><DIV><SPAN>"WeekDay"</SPAN><SPAN>, </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>WEEKDAY</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>, </SPAN><SPAN>2</SPAN><SPAN>) &lt; </SPAN><SPAN>6</SPAN><SPAN>, </SPAN><SPAN>"WeekDay"</SPAN><SPAN>, </SPAN><SPAN>"Weekend"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>"Day"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>[Date]</SPAN><SPAN>, </SPAN><SPAN>"dddd"</SPAN><SPAN>))</SPAN></DIV></DIV> Thu, 10 Aug 2023 16:17:26 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Format-Month/m-p/3374650#M7865 sportive92003 2023-08-10T16:17:26Z