topic Data transform using power query in Dataflow https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5109910#M5705 <P>Could you please someone suggest me for below issue. Thank you in advance.<BR /><BR />I have below format data&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>2026</STRONG></TD><TD><STRONG>actual</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>budget</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD></TR><TR><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>p1</STRONG></TD><TD><STRONG>p2</STRONG></TD><TD><STRONG>p3</STRONG></TD><TD><STRONG>p1</STRONG></TD><TD><STRONG>p2</STRONG></TD><TD><STRONG>p3</STRONG></TD></TR><TR><TD>revenue</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD></TR><TR><TD>food cost&nbsp;</TD><TD>7</TD><TD>8</TD><TD>9</TD><TD>10</TD><TD>11</TD><TD>12</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG>2025</STRONG></TD><TD><STRONG>actual</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>budget</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD></TR><TR><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>p1</STRONG></TD><TD><STRONG>p2</STRONG></TD><TD><STRONG>p3</STRONG></TD><TD><STRONG>p1</STRONG></TD><TD><STRONG>p2</STRONG></TD><TD><STRONG>p3</STRONG></TD></TR><TR><TD>revenue</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD></TR><TR><TD>food cost&nbsp;</TD><TD>7</TD><TD>8</TD><TD>9</TD><TD>10</TD><TD>11</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I transform this data to below format</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>subject</STRONG></TD><TD><STRONG>year</STRONG></TD><TD><STRONG>period</STRONG></TD><TD><STRONG>Actual</STRONG></TD><TD><STRONG>budget</STRONG></TD></TR><TR><TD>revenue</TD><TD>2026</TD><TD>p1</TD><TD>1</TD><TD>4</TD></TR><TR><TD>revenue</TD><TD>2026</TD><TD>p2</TD><TD>2</TD><TD>5</TD></TR><TR><TD>revenue</TD><TD>2026</TD><TD>p2</TD><TD>3</TD><TD>6</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2026</TD><TD>p1</TD><TD>7</TD><TD>10</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2026</TD><TD>p2</TD><TD>8</TD><TD>11</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2026</TD><TD>p2</TD><TD>9</TD><TD>12</TD></TR><TR><TD>revenue</TD><TD>2025</TD><TD>p1</TD><TD>1</TD><TD>4</TD></TR><TR><TD>revenue</TD><TD>2025</TD><TD>p2</TD><TD>2</TD><TD>5</TD></TR><TR><TD>revenue</TD><TD>2025</TD><TD>p2</TD><TD>3</TD><TD>6</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2025</TD><TD>p1</TD><TD>7</TD><TD>10</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2025</TD><TD>p2</TD><TD>8</TD><TD>11</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2025</TD><TD>p2</TD><TD>9</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P> Mon, 23 Feb 2026 06:28:51 GMT Anonymous 2026-02-23T06:28:51Z Data transform using power query https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5109910#M5705 <P>Could you please someone suggest me for below issue. Thank you in advance.<BR /><BR />I have below format data&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>2026</STRONG></TD><TD><STRONG>actual</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>budget</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD></TR><TR><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>p1</STRONG></TD><TD><STRONG>p2</STRONG></TD><TD><STRONG>p3</STRONG></TD><TD><STRONG>p1</STRONG></TD><TD><STRONG>p2</STRONG></TD><TD><STRONG>p3</STRONG></TD></TR><TR><TD>revenue</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD></TR><TR><TD>food cost&nbsp;</TD><TD>7</TD><TD>8</TD><TD>9</TD><TD>10</TD><TD>11</TD><TD>12</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG>2025</STRONG></TD><TD><STRONG>actual</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>budget</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>&nbsp;</STRONG></TD></TR><TR><TD><STRONG>&nbsp;</STRONG></TD><TD><STRONG>p1</STRONG></TD><TD><STRONG>p2</STRONG></TD><TD><STRONG>p3</STRONG></TD><TD><STRONG>p1</STRONG></TD><TD><STRONG>p2</STRONG></TD><TD><STRONG>p3</STRONG></TD></TR><TR><TD>revenue</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD></TR><TR><TD>food cost&nbsp;</TD><TD>7</TD><TD>8</TD><TD>9</TD><TD>10</TD><TD>11</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I transform this data to below format</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>subject</STRONG></TD><TD><STRONG>year</STRONG></TD><TD><STRONG>period</STRONG></TD><TD><STRONG>Actual</STRONG></TD><TD><STRONG>budget</STRONG></TD></TR><TR><TD>revenue</TD><TD>2026</TD><TD>p1</TD><TD>1</TD><TD>4</TD></TR><TR><TD>revenue</TD><TD>2026</TD><TD>p2</TD><TD>2</TD><TD>5</TD></TR><TR><TD>revenue</TD><TD>2026</TD><TD>p2</TD><TD>3</TD><TD>6</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2026</TD><TD>p1</TD><TD>7</TD><TD>10</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2026</TD><TD>p2</TD><TD>8</TD><TD>11</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2026</TD><TD>p2</TD><TD>9</TD><TD>12</TD></TR><TR><TD>revenue</TD><TD>2025</TD><TD>p1</TD><TD>1</TD><TD>4</TD></TR><TR><TD>revenue</TD><TD>2025</TD><TD>p2</TD><TD>2</TD><TD>5</TD></TR><TR><TD>revenue</TD><TD>2025</TD><TD>p2</TD><TD>3</TD><TD>6</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2025</TD><TD>p1</TD><TD>7</TD><TD>10</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2025</TD><TD>p2</TD><TD>8</TD><TD>11</TD></TR><TR><TD>food cost&nbsp;</TD><TD>2025</TD><TD>p2</TD><TD>9</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P> Mon, 23 Feb 2026 06:28:51 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5109910#M5705 Anonymous 2026-02-23T06:28:51Z Re: Data transform using power query https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5110128#M5706 <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR />Do not include sensitive information. Do not include anything that is unrelated to the issue or question. <BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Need help uploading data? <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Sun, 22 Feb 2026 20:45:12 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5110128#M5706 lbendlin 2026-02-22T20:45:12Z Re: Data transform using power query https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5111763#M5707 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="100342" data-lia-user-login="lbendlin" class="lia-mention lia-mention-user">lbendlin</a>&nbsp;Thankyou for your recommendation. I updated the data sample. Can you please suggest how to do it?</P> Mon, 23 Feb 2026 06:31:52 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5111763#M5707 Anonymous 2026-02-23T06:31:52Z Re: Data transform using power query https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5115499#M5708 <P>Hi&nbsp;Anonymous</a>,<BR /><BR /></P> <P><SPAN>The updated PBIX file is attached for your reference.<BR />Here, the data has been reshaped to the required format (Subject, Year, Period, Actual, Budget) using Power Query so that it can be used directly for reporting and further analysis.</SPAN></P> <P><SPAN>Please review the updated file and let us know if everything looks good or if any additional adjustments are needed.<BR /><BR /></SPAN>Thank you.</P> Mon, 23 Feb 2026 14:52:43 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5115499#M5708 v-echaithra 2026-02-23T14:52:43Z Re: Data transform using power query https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5120414#M5711 <P>Hi&nbsp;Anonymous</a>&nbsp;,<BR /><BR /></P> <P>We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.<BR /><BR /></P> <P>Best Regards,<BR />Chaithra E.</P> Thu, 26 Feb 2026 06:50:29 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5120414#M5711 v-echaithra 2026-02-26T06:50:29Z Re: Data transform using power query https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5124223#M5712 <P>Hi&nbsp;Anonymous</a>&nbsp;,<BR /><BR /></P> <P>May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.<BR /><BR /></P> <P>Thank you.</P> Mon, 02 Mar 2026 07:39:40 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5124223#M5712 v-echaithra 2026-03-02T07:39:40Z Re: Data transform using power query https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5125723#M5713 <P>Thank you for solving this issue. I helped me a lot.</P> Thu, 05 Mar 2026 01:48:01 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5125723#M5713 Anonymous 2026-03-05T01:48:01Z Re: Data transform using power query https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5359119#M5824 <P>Has the problem been resolved or not?</P> Thu, 13 Aug 2026 20:36:05 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-transform-using-power-query/m-p/5359119#M5824 Devvver 2026-08-13T20:36:05Z