https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dates-in-columns-and-variable/m-p/1749180#M36410 <P>That is a rather unfortunate table design. Have you considered unpivoting your month columns?</P> Sat, 27 Mar 2021 03:35:52 GMT lbendlin 2021-03-27T03:35:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dates-in-columns-and-variable/m-p/1746513#M36328 <P>Currently, I have an input like below with hundreds of extra columns:</P><TABLE><TBODY><TR><TD>Country</TD><TD>ID</TD><TD>Initiative</TD><TD>Cost</TD><TD>mar-21</TD><TD>apr-21</TD></TR><TR><TD>UK</TD><TD>1</TD><TD>1</TD><TD>100</TD><TD>30</TD><TD>40</TD></TR><TR><TD>US</TD><TD>2</TD><TD>2</TD><TD>150</TD><TD>12</TD><TD>11</TD></TR><TR><TD>IT</TD><TD>3</TD><TD>2</TD><TD>20</TD><TD>14</TD><TD>11</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I, without hard coding the current month (mar-21), identify the total per column which would be for UK = 30 and next month = 40? I need to create a new variable for current month.</P> Thu, 25 Mar 2021 19:57:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dates-in-columns-and-variable/m-p/1746513#M36328 Ludd 2021-03-25T19:57:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dates-in-columns-and-variable/m-p/1749180#M36410 <P>That is a rather unfortunate table design. Have you considered unpivoting your month columns?</P> Sat, 27 Mar 2021 03:35:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dates-in-columns-and-variable/m-p/1749180#M36410 lbendlin 2021-03-27T03:35:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dates-in-columns-and-variable/m-p/1751078#M36488 <P>Unpivoting does the trick. Thank you!</P> Mon, 29 Mar 2021 07:38:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dates-in-columns-and-variable/m-p/1751078#M36488 Ludd 2021-03-29T07:38:03Z