Go to Solution.
@Anonymous , what is the issue ? the first formula and one I am sharing should work with a date table. Marked as date Table. Make sure Date table is Marked as date Table
Previous month = CALCULATE([Count of delivery note] , PREVIOUSMONTH(Dates[Date]))
last MTD (complete) Sales = CALCULATE(SUM([Count of delivery note] ,DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
View solution in original post
Thanks now it works!
Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!