https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamically-computing-months-column/m-p/750208#M2673 <P>I have added Pivot steps in my table&nbsp; and this made my months column (Jan to Jun) appear. The next step am the below query to replace column values using&nbsp;</P><P>Table.ReplaceValue(#"Pivoted Column",null,0,Replacer.ReplaceValue,{"JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC"})</P><P>&nbsp;</P><P>The problem here is since I dont have no data from Jul to Dec, the query fails to execute. How do I dynamically make the list of month's appear in the above formula ?</P> Fri, 26 Jul 2019 15:23:50 GMT smathew8 2019-07-26T15:23:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamically-computing-months-column/m-p/750208#M2673 <P>I have added Pivot steps in my table&nbsp; and this made my months column (Jan to Jun) appear. The next step am the below query to replace column values using&nbsp;</P><P>Table.ReplaceValue(#"Pivoted Column",null,0,Replacer.ReplaceValue,{"JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC"})</P><P>&nbsp;</P><P>The problem here is since I dont have no data from Jul to Dec, the query fails to execute. How do I dynamically make the list of month's appear in the above formula ?</P> Fri, 26 Jul 2019 15:23:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamically-computing-months-column/m-p/750208#M2673 smathew8 2019-07-26T15:23:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamically-computing-months-column/m-p/750221#M2674 <P>This forum is on DAX, not on PQ. Please ask the question on the relevant forum.</P><P>&nbsp;</P><P>Best<BR />Darek</P> Fri, 26 Jul 2019 15:33:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamically-computing-months-column/m-p/750221#M2674 Anonymous 2019-07-26T15:33:01Z