topic Re: sales last week as default in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sales-last-week-as-default/m-p/3997724#M155471 <P>exactly!</P> Tue, 18 Jun 2024 07:51:20 GMT Anonymous 2024-06-18T07:51:20Z sales last week as default https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sales-last-week-as-default/m-p/3990792#M154799 <P>Hi, I want to create a calculated measure or column that has me select last week's sales and sales from the beginning of the year to last week. I want this to also be a filter so that I can decide if I want to see sales either by previous week or all weeks up to the previous week. What code should I write?<BR />Thank you</P> Thu, 13 Jun 2024 09:54:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sales-last-week-as-default/m-p/3990792#M154799 Anonymous 2024-06-13T09:54:14Z Re: sales last week as default https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sales-last-week-as-default/m-p/3992021#M154923 <P>What does "week"&nbsp; mean to you?&nbsp; Does your calendar table have yearweek numbers?</P> Fri, 14 Jun 2024 01:02:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sales-last-week-as-default/m-p/3992021#M154923 lbendlin 2024-06-14T01:02:24Z Re: sales last week as default https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sales-last-week-as-default/m-p/3997724#M155471 <P>exactly!</P> Tue, 18 Jun 2024 07:51:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sales-last-week-as-default/m-p/3997724#M155471 Anonymous 2024-06-18T07:51:20Z