Filtered last calendar month and YTD - please help

[The_Clam]

Hi.  I need help building a report/matrix.  For a specific location, I require one colum that shows sum of TICKETS per RESOLUTION for the last 1 calendar month (March in this case) and one colum that shows the YTD total.

Expected Result (for Building 7)

Resolution	March	YTD
Link	2	5
Power-Company		1

Data:

TicketNumber	Closed Date	Resolution	Building
254775	2/12/2021	Link	7
255557	2/12/2021	Hardware	1
258191	2/19/2021	Link	7
258198	2/26/2021	Power - Company	7
258491	2/18/2021	Link	7
262196	3/3/2021	Link	7
262365	3/3/2021	Link	7
267282	3/18/2021	Link	9
270000	3/26/2021	Hardware	8
271080	4/1/2021	Link	8

[amitchandak · Accepted solution]

@The_Clam , You can use datesmtd and datesytd with date table and use building slicer

example

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[The_Clam]

Hi.  Thanks for the reply.  I am able to get YTD and MTD, but what I need is the ticket count (not sales) for the previous month, so if I ran the report today, I need the ticket count for March and YTD.  Your answer pointed me in the right direction.  Thanks!