MTD and YTD calculation
@ Power BI users, When I try to use SAMEPERIODLASTYEAR to get MTD of previous year, it returns entire months billed hours sum, rather I was looking for only till current year date sum as in screenshot below. Also when i try to use Dateadd function Billed Hours previous Year, it gives me the entire year total Example- I want to view this year MTD ie from Jan 1-Jan 19, 2021 Vs Jan1-Jan 19, 2020 (Screenshot below). Currently i am getting the entire month total highlighted in black but i want to get total till Jan 19, 2020 highlighted in blue. Following are the measures i used Billed Hours current Year = Sum(FACT_Monthly_Sales_By_business_Line[Duration Billed]) Billed Hours Last_Year_MTD = CALCULATE ( [Billed Hours], SAMEPERIODLASTYEAR(DATESMTD( 'Calendar'[Date]))) Billed Hours Last_Year_YTD = CALCULATE([Billed Hours], DATEADD('Calendar'[Date], -1, YEAR)) I tried using this link too but was unable to get the expected result.
