How to return single value from a column

[ColePatrick]

Hi,

I’m new to Power BI. Using the sample data below I can determine Monthly Variance and MoM with Power BI measures. I can even return the Year To Date total.

Where I’m struggling is return Monthly Units for current month  (6/1/2022 below). I need to print it out as “Cur Month”  with formatting so I think I need to create a measure  like below – however that returns the Year to Date number.

"Cur Mon: (" & FORMAT(SUM('Monthly Units]), "###" )  & ")

I need to solve this without using a Date slicer, so does that mean using the DAX Filter function? 

FirstOfMonth	Monthly Units	Prev Monthly Units	Monthly Variance	MoM
7/1/2021	3	0	3
8/1/2021	3	3	0	0.00%
9/1/2021	1	3	-2	-66.67%
10/1/2021	1	1	0	0.00%
11/1/2021	3	1	2	200.00%
12/1/2021	2	3	-1	-33.33%
1/1/2022	2	2	0	0.00%
2/1/2022	10	2	8	400.00%
3/1/2022	5	10	-5	-50.00%
4/1/2022	2	5	-3	-60.00%
5/1/2022	4	2	2	100.00%
6/1/2022	3	4	-1	-25.00%
	39	36

Thanks in advance.

[parry2k]

@ColePatrick where you want this to be show "Cur Mon: (" & FORMAT(SUM('Monthly Units]), "###" )  & ")