topic How to show beginning of Quarter and dived the dollars won in that Quarter in DAX Using WeekNumber in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-beginning-of-Quarter-and-dived-the-dollars-won-in/m-p/3544401#M136277 <P>Hi Folks,</P><P>i have multiple columns in the table . i want use WeekNumber , Dollors. There are multiple values in every week. For sample i am showing few. i want to get this below using weeknumber and Dollors. Can you please help me in this. How to create DAX.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>WeekNumber</TD><TD>Dollors</TD></TR><TR><TD>202201</TD><TD>10</TD></TR><TR><TD>202202</TD><TD>20</TD></TR><TR><TD>202203</TD><TD>30</TD></TR><TR><TD>202204</TD><TD>60</TD></TR><TR><TD>202205</TD><TD>70</TD></TR><TR><TD>202206</TD><TD>90</TD></TR><TR><TD>202207</TD><TD>100</TD></TR><TR><TD>202208</TD><TD>200</TD></TR><TR><TD>202209</TD><TD>100</TD></TR><TR><TD>202210</TD><TD>110</TD></TR><TR><TD>202211</TD><TD>120</TD></TR><TR><TD>202212</TD><TD>130</TD></TR><TR><TD>202301</TD><TD>160</TD></TR><TR><TD>202302</TD><TD>180</TD></TR><TR><TD>202303</TD><TD>190</TD></TR><TR><TD>202304</TD><TD>200</TD></TR><TR><TD>202305</TD><TD>250</TD></TR><TR><TD>202306</TD><TD>300</TD></TR><TR><TD>202307</TD><TD>400</TD></TR><TR><TD>202308</TD><TD>5000</TD></TR><TR><TD>202309</TD><TD>400</TD></TR><TR><TD>202310</TD><TD>200</TD></TR><TR><TD>202311</TD><TD>100</TD></TR></TBODY></TABLE><P><img /></P> Tue, 21 Nov 2023 10:40:50 GMT Gopal_PV 2023-11-21T10:40:50Z How to show beginning of Quarter and dived the dollars won in that Quarter in DAX Using WeekNumber https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-beginning-of-Quarter-and-dived-the-dollars-won-in/m-p/3544401#M136277 <P>Hi Folks,</P><P>i have multiple columns in the table . i want use WeekNumber , Dollors. There are multiple values in every week. For sample i am showing few. i want to get this below using weeknumber and Dollors. Can you please help me in this. How to create DAX.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>WeekNumber</TD><TD>Dollors</TD></TR><TR><TD>202201</TD><TD>10</TD></TR><TR><TD>202202</TD><TD>20</TD></TR><TR><TD>202203</TD><TD>30</TD></TR><TR><TD>202204</TD><TD>60</TD></TR><TR><TD>202205</TD><TD>70</TD></TR><TR><TD>202206</TD><TD>90</TD></TR><TR><TD>202207</TD><TD>100</TD></TR><TR><TD>202208</TD><TD>200</TD></TR><TR><TD>202209</TD><TD>100</TD></TR><TR><TD>202210</TD><TD>110</TD></TR><TR><TD>202211</TD><TD>120</TD></TR><TR><TD>202212</TD><TD>130</TD></TR><TR><TD>202301</TD><TD>160</TD></TR><TR><TD>202302</TD><TD>180</TD></TR><TR><TD>202303</TD><TD>190</TD></TR><TR><TD>202304</TD><TD>200</TD></TR><TR><TD>202305</TD><TD>250</TD></TR><TR><TD>202306</TD><TD>300</TD></TR><TR><TD>202307</TD><TD>400</TD></TR><TR><TD>202308</TD><TD>5000</TD></TR><TR><TD>202309</TD><TD>400</TD></TR><TR><TD>202310</TD><TD>200</TD></TR><TR><TD>202311</TD><TD>100</TD></TR></TBODY></TABLE><P><img /></P> Tue, 21 Nov 2023 10:40:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-beginning-of-Quarter-and-dived-the-dollars-won-in/m-p/3544401#M136277 Gopal_PV 2023-11-21T10:40:50Z Re: How to show beginning of Quarter and dived the dollars won in that Quarter in DAX Using WeekNumber https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-beginning-of-Quarter-and-dived-the-dollars-won-in/m-p/3548001#M136450 <P>Please provide better sample data, covering more than two quarters. Clearly indicate which week belongs to which quarter.&nbsp; Ideally you would have a date column that you could tie to a calendar table.</P> Thu, 23 Nov 2023 02:27:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-beginning-of-Quarter-and-dived-the-dollars-won-in/m-p/3548001#M136450 lbendlin 2023-11-23T02:27:53Z