https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-projection/m-p/1766909#M156560 <P>Good night.<BR />I have the following problem Community I have the following table in which I am generating the rotation calculation, that calculation what I am generating <STRONG>as follows, the total casualties between the total workforce per month and year.</STRONG></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shadyrenato_1-1617699483689.png" style="width: 400px;"><IMG src="https://ip1.i.lithium.com/d0011db20f24e596d626006a355f3fff9d2d6cd4/68747470733a2f2f636f6d6d756e6974792e706f77657262692e636f6d2f74352f696d6167652f736572766572706167652f696d6167652d69642f34383836313169333536373242313230433135343744413f763d7632" role="button" title="shadyrenato_1-1617699483689.png" alt="shadyrenato_1-1617699483689.png" /></SPAN></P><P>The problem is that I only occupy the project of the month of March, instead of having 5.5% I would have to show 10.1% as shown in the following Excel table, the dax that I am using to make the projection is the next projected rotation (Rotation / 17)*31 being 17 the number of days and 31 corresponding to the total days of the month of March.<BR />As it looks on the table. January and February only divides the casualties between the template and the month of March only the projection of the aforementioned calculation, projected rotation <STRONG>(Rotation / 17)*31 is calculated </STRONG></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shadyrenato_2-1617699585341.png" style="width: 400px;"><IMG src="https://ip1.i.lithium.com/9bfd53f11517f363c872d5b3d820aae39ada9e53/68747470733a2f2f636f6d6d756e6974792e706f77657262692e636f6d2f74352f696d6167652f736572766572706167652f696d6167652d69642f34383836313269463244363543394233453142314439413f763d7632" role="button" title="shadyrenato_2-1617699585341.png" alt="shadyrenato_2-1617699585341.png" /></SPAN><BR /><FONT>This to represent a chart as follows.</FONT></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shadyrenato_3-1617699770518.png" style="width: 400px;"><IMG src="https://ip1.i.lithium.com/259cdb1e1fc62e02234a2494e6be99d72fc549b4/68747470733a2f2f636f6d6d756e6974792e706f77657262692e636f6d2f74352f696d6167652f736572766572706167652f696d6167652d69642f34383836313469453643324431424444454335353844443f763d7632" role="button" title="shadyrenato_3-1617699770518.png" alt="shadyrenato_3-1617699770518.png" /></SPAN></P><P> </P><P>if anyone knows how to make such a calculation, they would be greatly assaulted.</P><P><BR /><BR /></P><P> </P> Tue, 06 Apr 2021 09:34:14 GMT Syndicate_Admin 2021-04-06T09:34:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-projection/m-p/1766909#M156560 <P>Good night.<BR />I have the following problem Community I have the following table in which I am generating the rotation calculation, that calculation what I am generating <STRONG>as follows, the total casualties between the total workforce per month and year.</STRONG></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shadyrenato_1-1617699483689.png" style="width: 400px;"><IMG src="https://ip1.i.lithium.com/d0011db20f24e596d626006a355f3fff9d2d6cd4/68747470733a2f2f636f6d6d756e6974792e706f77657262692e636f6d2f74352f696d6167652f736572766572706167652f696d6167652d69642f34383836313169333536373242313230433135343744413f763d7632" role="button" title="shadyrenato_1-1617699483689.png" alt="shadyrenato_1-1617699483689.png" /></SPAN></P><P>The problem is that I only occupy the project of the month of March, instead of having 5.5% I would have to show 10.1% as shown in the following Excel table, the dax that I am using to make the projection is the next projected rotation (Rotation / 17)*31 being 17 the number of days and 31 corresponding to the total days of the month of March.<BR />As it looks on the table. January and February only divides the casualties between the template and the month of March only the projection of the aforementioned calculation, projected rotation <STRONG>(Rotation / 17)*31 is calculated </STRONG></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shadyrenato_2-1617699585341.png" style="width: 400px;"><IMG src="https://ip1.i.lithium.com/9bfd53f11517f363c872d5b3d820aae39ada9e53/68747470733a2f2f636f6d6d756e6974792e706f77657262692e636f6d2f74352f696d6167652f736572766572706167652f696d6167652d69642f34383836313269463244363543394233453142314439413f763d7632" role="button" title="shadyrenato_2-1617699585341.png" alt="shadyrenato_2-1617699585341.png" /></SPAN><BR /><FONT>This to represent a chart as follows.</FONT></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shadyrenato_3-1617699770518.png" style="width: 400px;"><IMG src="https://ip1.i.lithium.com/259cdb1e1fc62e02234a2494e6be99d72fc549b4/68747470733a2f2f636f6d6d756e6974792e706f77657262692e636f6d2f74352f696d6167652f736572766572706167652f696d6167652d69642f34383836313469453643324431424444454335353844443f763d7632" role="button" title="shadyrenato_3-1617699770518.png" alt="shadyrenato_3-1617699770518.png" /></SPAN></P><P> </P><P>if anyone knows how to make such a calculation, they would be greatly assaulted.</P><P><BR /><BR /></P><P> </P> Tue, 06 Apr 2021 09:34:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-projection/m-p/1766909#M156560 Syndicate_Admin 2021-04-06T09:34:14Z