https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-for-sum-of-last-month-revenue/m-p/1490705#M28649 <DIV><DIV><SPAN>Hi,<BR />I have a measure that calculates full monthly revenue based on specified dates, for example October:<BR />Rev2020-10-Qta&amp;NRMUsg = CALCULATE(SUM(Transactions[DailyUsage$NRMusg])</SPAN></DIV><DIV><SPAN>, DATESBETWEEN(Dates[Date], </SPAN></DIV><DIV><SPAN>DATE(2020,10,1), </SPAN></DIV><DIV><SPAN>DATE(2020,10,31) </SPAN></DIV><DIV><SPAN>))<BR />This measure is used on some Power BI pages that don't have any slicers or applied time periods.<BR /><BR />How can I build a dynamic measure that would return the same value, without having to "hard code" the dates? I've tried PreviousMonth and other functions, but could not set it up properly to work with those requirements:<BR />- Previous Month should be calculated based on the current month, as of today<BR />- It will not get the value from a slicer or a filter on the page<BR />- Must be the entire full last month<BR /><BR />Thanks for your help!<BR />Erik<BR /><BR /><BR /><BR /><BR /></SPAN></DIV></DIV> Thu, 12 Nov 2020 15:53:56 GMT Anonymous 2020-11-12T15:53:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-for-sum-of-last-month-revenue/m-p/1490705#M28649 <DIV><DIV><SPAN>Hi,<BR />I have a measure that calculates full monthly revenue based on specified dates, for example October:<BR />Rev2020-10-Qta&amp;NRMUsg = CALCULATE(SUM(Transactions[DailyUsage$NRMusg])</SPAN></DIV><DIV><SPAN>, DATESBETWEEN(Dates[Date], </SPAN></DIV><DIV><SPAN>DATE(2020,10,1), </SPAN></DIV><DIV><SPAN>DATE(2020,10,31) </SPAN></DIV><DIV><SPAN>))<BR />This measure is used on some Power BI pages that don't have any slicers or applied time periods.<BR /><BR />How can I build a dynamic measure that would return the same value, without having to "hard code" the dates? I've tried PreviousMonth and other functions, but could not set it up properly to work with those requirements:<BR />- Previous Month should be calculated based on the current month, as of today<BR />- It will not get the value from a slicer or a filter on the page<BR />- Must be the entire full last month<BR /><BR />Thanks for your help!<BR />Erik<BR /><BR /><BR /><BR /><BR /></SPAN></DIV></DIV> Thu, 12 Nov 2020 15:53:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-for-sum-of-last-month-revenue/m-p/1490705#M28649 Anonymous 2020-11-12T15:53:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-for-sum-of-last-month-revenue/m-p/1491329#M28669 <P>Found it via another post on this forum. Here's the equivalent formula:<BR /><BR /></P><DIV><DIV><SPAN>RevLastLmonthQta&amp;NRMUsg = CALCULATE(SUM(Transactions[DailyUsage$NRMusg]),</SPAN></DIV><DIV><SPAN>DATESBETWEEN(Dates[Date],DATE(YEAR(TODAY()),MONTH(TODAY())-1,01),DATE(YEAR(TODAY()),MONTH(TODAY()),01)-1))</SPAN></DIV></DIV> Thu, 12 Nov 2020 23:25:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-for-sum-of-last-month-revenue/m-p/1491329#M28669 Anonymous 2020-11-12T23:25:56Z