https://www.spguides.com/power-bi-current-month-report/ Learn SharePoint, Office 365, Nintex, PowerApps, PowerBI etc, SharePoint training and video courses Mon, 04 Mar 2024 13:21:43 +0000 hourly 1 https://wordpress.org/?v=6.6.2 https://www.spguides.com/power-bi-current-month-report/#comments/1069 Mon, 04 Mar 2024 13:21:43 +0000 https://www.sharepointsky.com/?p=16255#comment-1069 This doesn’t work if you have multiple years in the dataset. For example, I need to compare this month to last month. Using the measures provided, it will count all sales for March reglardless of year. Therefore, it’s calculating all sales in March over the years, not just March 2024. Is there a way to only calculate current months sales? I’ve seen measures that also look at current year, but this wont work for previous sales if the current month is January. Any ideas?

]]>