https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Having-an-issue-with-DoW-analysis-in-Dax/m-p/3462826#M132102 <P>Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue. <BR />If you are unsure how to do that please refer to <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 />Please show the expected outcome based on the sample data you provided. <BR /><BR />If you want to get answers faster please refer to <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> Fri, 06 Oct 2023 01:55:03 GMT lbendlin 2023-10-06T01:55:03Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Having-an-issue-with-DoW-analysis-in-Dax/m-p/3459704#M131957 <P>Needing help resolve this issue - I have figured out how to display the Last 60, last 30, etc...&nbsp;</P><P>&nbsp;</P><P>When I put the totals in a table and breakout by DoW its giving me the last 30 of that specified DoW. How can I fix this to show me the Lx days Traffic distributed by DoW.&nbsp;<BR /><BR />Context:&nbsp;<BR /><BR />Dax used -&nbsp;</P><DIV><DIV><SPAN>Traffic L30 =</SPAN> <SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[Traffic]</SPAN><SPAN>,</SPAN><SPAN>DATESINPERIOD</SPAN><SPAN>(</SPAN><SPAN>'Date Table'</SPAN><SPAN>[Date]</SPAN><SPAN>,</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'Date Table'</SPAN><SPAN>[Date]</SPAN><SPAN>),-</SPAN><SPAN>31</SPAN><SPAN>,</SPAN><SPAN>DAY</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Wed, 04 Oct 2023 14:22:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Having-an-issue-with-DoW-analysis-in-Dax/m-p/3459704#M131957 Anonymous 2023-10-04T14:22:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Having-an-issue-with-DoW-analysis-in-Dax/m-p/3462826#M132102 <P>Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue. <BR />If you are unsure how to do that please refer to <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 />Please show the expected outcome based on the sample data you provided. <BR /><BR />If you want to get answers faster please refer to <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> Fri, 06 Oct 2023 01:55:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Having-an-issue-with-DoW-analysis-in-Dax/m-p/3462826#M132102 lbendlin 2023-10-06T01:55:03Z