Forum Discussion

ColePatrick's avatar
ColePatrick
New Member
3 years ago

How to return single value from a column

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.

1 Reply