https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Columns/m-p/3121660#M110727 <P>Month 1&nbsp; = 744 Hr</P><P>Month 2&nbsp; = 640.62 Hr</P><P>Month 3 = 144 Hr</P><P>&nbsp;</P><P>Thanks.</P><P>&nbsp;</P><P>Gian</P> Thu, 09 Mar 2023 13:52:50 GMT gianchan 2023-03-09T13:52:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Columns/m-p/3119705#M110582 <P>Hi all,</P><P>&nbsp;</P><P>How can I sum the Start Month Hour&nbsp; and the End Month Hour for each month? The Start Month and End Month may not have the same values.</P><P>&nbsp;</P><P>Thanks,</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Start Month</TD><TD>End Month</TD><TD>Start Month Hour</TD><TD>End Month Hour</TD></TR><TR><TD>1</TD><TD>1</TD><TD>81.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>1</TD><TD>24.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>1</TD><TD>135.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>1</TD><TD>17.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>1</TD><TD>184.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>1</TD><TD>111.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>1</TD><TD>24.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>1</TD><TD>33.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>1</TD><TD>24.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>1</TD><TD>48.00</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>2</TD><TD>63.00</TD><TD>33.00</TD></TR><TR><TD>2</TD><TD>2</TD><TD>45.00</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>2</TD><TD>0.72</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>2</TD><TD>0.40</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>2</TD><TD>18.85</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>2</TD><TD>449.95</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>2</TD><TD>10.98</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>3</TD><TD>81.72</TD><TD>144.00</TD></TR></TBODY></TABLE> Wed, 08 Mar 2023 19:06:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Columns/m-p/3119705#M110582 gianchan 2023-03-08T19:06:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Columns/m-p/3119917#M110593 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="134055" data-lia-user-login="gianchan" class="lia-mention lia-mention-user">gianchan</a>&nbsp;</P><P>could you also provide the expected result?</P> Wed, 08 Mar 2023 21:42:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Columns/m-p/3119917#M110593 FreemanZ 2023-03-08T21:42:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Columns/m-p/3121660#M110727 <P>Month 1&nbsp; = 744 Hr</P><P>Month 2&nbsp; = 640.62 Hr</P><P>Month 3 = 144 Hr</P><P>&nbsp;</P><P>Thanks.</P><P>&nbsp;</P><P>Gian</P> Thu, 09 Mar 2023 13:52:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Columns/m-p/3121660#M110727 gianchan 2023-03-09T13:52:50Z